Re: pg_dump: fail to restore partition table with serial type

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: pg_dump: fail to restore partition table with serial type
Дата
Msg-id 30015.1560386817@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: pg_dump: fail to restore partition table with serial type  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Ответы Re: pg_dump: fail to restore partition table with serial type  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Список pgsql-hackers
Alvaro Herrera <alvherre@2ndquadrant.com> writes:
> There was indeed one more problem, that only the pg10 pg_upgrade test
> detected.  Namely, binary-upgrade dump didn't restore for locally
> defined constraints: they were dumped twice, first in the table
> definition and later by the ALTER TABLE ADD CONSTRAINT bit for binary
> upgrade that I had failed to notice.  Ooops.  The reason pg10 detected
> it and the other branches didn't, is that the only constraint of this
> ilk that remained after running regress was removed by 05bd889904e0 :-(

Seems like we'd better put back some coverage for that case, no?
But I'm confused by your reference to 05bd889904e0.  It looks like
that didn't change anything about tables that weren't getting dropped
anyhow.

            regards, tom lane



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: proposal: new polymorphic types - commontype and commontypearray
Следующее
От: Peter Geoghegan
Дата:
Сообщение: Re: PG 12 draft release notes