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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Gabriele Bartolini" <g(dot)bartolini(at)comune(dot)prato(dot)it>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #3224: Dump: missing schema name for sequence in a "DEFAULT nextval" specification
Date: 2007-04-13 15:15:45
Message-ID: 19419.1176477345@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"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

Browse pgsql-bugs by date

  From Date Subject
Next Message Gabriele Bartolini 2007-04-13 23:19:11 R: BUG #3224: Dump: missing schema name for sequence in a "DEFAULT nextval" specification
Previous Message Tom Lane 2007-04-13 15:14:10 Re: BUG #3225: BitmapOr plan node does not show currect row count