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

From: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
To: Gabriele Bartolini <g(dot)bartolini(at)comune(dot)prato(dot)it>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: R: BUG #3224: Dump: missing schema name for sequence in a "DEFAULT nextval" specification
Date: 2007-04-15 04:27:35
Message-ID: 20070415042735.GD4537@alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Kazuhiro Inaoka 2007-04-16 04:18:02 BUG #3228: Linux/M32R project
Previous Message Hiroshi Inoue 2007-04-14 23:03:22 Re: BUG #3226: ODBC driver 8.02.02 parses subqueries incorrectly