Skip site navigation (1) Skip section navigation (2)

R: BUG #3224: Dump: missing schema name for sequence in a "DEFAULT nextval" specification

From: "Gabriele Bartolini" <g(dot)bartolini(at)comune(dot)prato(dot)it>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: <pgsql-bugs(at)postgresql(dot)org>
Subject: R: BUG #3224: Dump: missing schema name for sequence in a "DEFAULT nextval" specification
Date: 2007-04-13 23:19:11
Message-ID: 910CF843580B3C40A25CD0D04B3908E209C589@exchange4.comune.prato.local (view raw or flat)
Thread:
Lists: pgsql-bugs
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:tgl(at)sss(dot)pgh(dot)pa(dot)us]
Inviato: ven 13/04/2007 17.15
A: Gabriele Bartolini
Cc: pgsql-bugs(at)postgresql(dot)org
Oggetto: Re: [BUGS] BUG #3224: Dump: missing schema name for sequence in a "DEFAULT nextval" specification 
 
"Gabriele Bartolini" <g(dot)bartolini(at)comune(dot)prato(dot)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

In response to

Responses

pgsql-bugs by date

Next:From: Russell SmithDate: 2007-04-14 01:02:40
Subject: Re: BUG #3225: BitmapOr plan node does not show currect row count
Previous:From: Tom LaneDate: 2007-04-13 15:15:45
Subject: Re: BUG #3224: Dump: missing schema name for sequence in a "DEFAULT nextval" specification

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group