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?