From: Tom Lane <tgl@sss.pgh.pa.us>
To: chester c young <chestercyoung@yahoo.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: pg_dump not correctly saving schema with partitioned tables?
Date: Tue, 31 Jan 2012 16:04:18 -0500
Message-ID: <10378.1328043858@sss.pgh.pa.us> (raw)
In-Reply-To: <1328015852.22615.YahooMailClassic@web161404.mail.bf1.yahoo.com>
References: <1328015852.22615.YahooMailClassic@web161404.mail.bf1.yahoo.com>
chester c young <chestercyoung@yahoo.com> writes:
> have database with many partitions. each partition table has its own primary key sequence.
> Column || Modifiers
> -----------++--------------------------------------------------------------
> uno_id || not null default nextval('cmp0004.cmt_uno_id_seq'::regclass)
> when dumped and then resorted, the pk sequence is changed to an inherited- from table:
> Column || Modifiers
> --------------++------------------------------------------------------
> uno_id || not null default nextval('uno_uno_id_seq'::regclass)
> (another error is that the pk sequence does not spec the schema!)
I see no reason to think there is a bug here; it's more likely that you
do not understand the display behavior of regclass constants. They only
print a schema name if your current search_path is such that the
relation wouldn't be found by writing just the unqualified name.
So the most likely explanation for the discrepancy above is that you
executed the two \d commands under different search_path settings.
It's possible that you have actually found a pg_dump bug, but if so
you'll need to submit a complete test-case exhibiting the bug.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: tgl@sss.pgh.pa.us, chestercyoung@yahoo.com
Subject: Re: pg_dump not correctly saving schema with partitioned tables?
In-Reply-To: <10378.1328043858@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox