Re: BUG #13656: table inheritance, pg_dump emits same constraint for all inheritors causing errors

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #13656: table inheritance, pg_dump emits same constraint for all inheritors causing errors
Дата
Msg-id 23590.1443725377@sss.pgh.pa.us
обсуждение исходный текст
Ответ на BUG #13656: table inheritance, pg_dump emits same constraint for all inheritors causing errors  (swingi@gmail.com)
Ответы Re: BUG #13656: table inheritance, pg_dump emits same constraint for all inheritors causing errors  (Michael Paquier <michael.paquier@gmail.com>)
Список pgsql-bugs
swingi@gmail.com writes:
> I just noticed that when you add a not valid constraint to a table that is
> inherited, this will result in pg_dump emitting an add constraint operation
> for every table in the inheritance hierarchy. Therefore restoring a dump
> will cause errors. Below is an example, first with a valid constraint (goes
> well), and then the not valid constraint.

Seems to be a simple oversight in the code for handling not-valid
constraints.  Thanks for the report!

            regards, tom lane

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

Предыдущее
От: Josh Berkus
Дата:
Сообщение: Re: GRANT USAGE ON SEQUENCE missing from psql command completion
Следующее
От: Thomas Munro
Дата:
Сообщение: Re: GRANT USAGE ON SEQUENCE missing from psql command completion