pg_dump not correctly saving schema with partitioned tables?

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?

Responses

Browse pgsql-sql by date

  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