On Thu, Jul 19, 2012 at 1:13 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Luiz Damim <luizvd(at)gmail(dot)com> 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.