Re: BUG #3224: Dump: missing schema name for sequence in a "DEFAULT nextval" specification - Mailing list pgsql-bugs

"Gabriele Bartolini" <g.bartolini@comune.prato.it> writes:
> However, when I issue a pg_dump or pg_dumpall command, here is what I get:

> SET search_path = dimensions, pg_catalog;
> CREATE SEQUENCE hosts_2006_seq;
> CREATE TABLE hosts_2006 (
>     id_host integer DEFAULT nextval('hosts_2006_seq'::regclass) NOT NULL,
>     host character varying(255) DEFAULT ''::character varying NOT NULL,
> );

This is not a bug: the regclass constant will be recreated the same as
it was before.

            regards, tom lane