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

From Alvaro Herrera
Subject Re: R: BUG #3224: Dump: missing schema name for sequence in a "DEFAULT nextval" specification
Date
Msg-id 20070415042735.GD4537@alvh.no-ip.org
Whole thread Raw
In response to R: BUG #3224: Dump: missing schema name for sequence in a "DEFAULT nextval" specification  ("Gabriele Bartolini" <g.bartolini@comune.prato.it>)
List pgsql-bugs
Gabriele Bartolini wrote:
> 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.

It disappeared because it's not necessary.  The search_path setting just
above makes sure that it is restored correctly.


--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

pgsql-bugs by date:

Previous
From: Hiroshi Inoue
Date:
Subject: Re: BUG #3226: ODBC driver 8.02.02 parses subqueries incorrectly
Next
From: David Darville
Date:
Subject: Re: Continuous archiving fails