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?
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
