From: | chester c young <chestercyoung(at)yahoo(dot)com> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | pg_dump not correctly saving schema with partitioned tables? |
Date: | 2012-01-31 13:17:32 |
Message-ID: | 1328015852.22615.YahooMailClassic@web161404.mail.bf1.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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!)
is there any way I can reliably backup and restore the db?
From | Date | Subject | |
---|---|---|---|
Next Message | Edward W. Rouse | 2012-01-31 20:27:03 | must appear in the GROUP BY clause or be used in an aggregate function problem |
Previous Message | Steve Crawford | 2012-01-30 18:09:57 | Re: querying a column w/ timestamp with timezone datatype |