Hi Tom, thanks for the answer. However, I still cannot understand why the 'dimensions' schema has disappeared from the dump of the sequence. I will do further investigation and let you know.
Ciao, Gabriele P.S.: Would you think of coming to the Italian PostgreSQL Day in July? I am one of the main organisers of the event. -----Messaggio originale----- Da: Tom Lane [mailto:[EMAIL PROTECTED] Inviato: ven 13/04/2007 17.15 A: Gabriele Bartolini Cc: [EMAIL PROTECTED] Oggetto: Re: [BUGS] BUG #3224: Dump: missing schema name for sequence in a "DEFAULT nextval" specification "Gabriele Bartolini" <[EMAIL PROTECTED]> 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
