On Thu, Jul 19, 2012 at 1:13 PM, Tom Lane <[email protected]> wrote: > Luiz Damim <[email protected]> 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 ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
