Hi Tom,
thanks for the answer. However, I still cannot understand why the 'dimen=
sions' schema has disappeared from the dump of the sequence. I will do furt=
her 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:tgl@sss.pgh.pa.us]
Inviato: ven 13/04/2007 17.15
A: Gabriele Bartolini
Cc: pgsql-bugs@postgresql.org
Oggetto: Re: [BUGS] BUG #3224: Dump: missing schema name for sequence in a =
"DEFAULT nextval" specification=20
=20
"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 =3D 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