On Thu, Jul 19, 2012 at 1:13 PM, Tom Lane <tgl@xxxxxxxxxxxxx> wrote:
> Luiz Damim <luizvd@xxxxxxxxx> writes:
>> After restore, default_value changes to
>> nextval('testtable_id_seq'::regclass) and INSERT's start to fail as the
>> sequence can´t be found on it's schema.
>
> This claim is utter nonsense. If you are having a problem it's not due
> to the way regclass literals print. Please show a complete example of
> something failing.
Is it possible the OP has an "alter user set search_path=..." in their
original db that's not getting backed up here because they're not
backing up globals? Seems a more reasonable explanation to me.
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
