pg_dump not correctly saving schema with partitioned tables?

Поиск
Список
Период
Сортировка
От chester c young
Тема pg_dump not correctly saving schema with partitioned tables?
Дата
Msg-id 1328015852.22615.YahooMailClassic@web161404.mail.bf1.yahoo.com
обсуждение исходный текст
Ответы Re: pg_dump not correctly saving schema with partitioned tables?
Список 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?




В списке pgsql-sql по дате отправления:

Предыдущее
От: Steve Crawford
Дата:
Сообщение: Re: querying a column w/ timestamp with timezone datatype
Следующее
От: "Edward W. Rouse"
Дата:
Сообщение: must appear in the GROUP BY clause or be used in an aggregate function problem