Re: Cannot dump foreign key constraints on partitioned table

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: Cannot dump foreign key constraints on partitioned table
Дата
Msg-id 20180712184537.5vjwgxlbuiomomqd@alvherre.pgsql
обсуждение исходный текст
Ответ на Re: Cannot dump foreign key constraints on partitioned table  (Michael Paquier <michael@paquier.xyz>)
Ответы Re: Cannot dump foreign key constraints on partitioned table  (Michael Paquier <michael@paquier.xyz>)
Список pgsql-hackers
On 2018-Jul-12, Michael Paquier wrote:

> Changing pg_class.relhastriggers is out of scope because as far as I
> know partitioned tables have no triggers, so the current value is
> correct, and that would be a catalog change at this stage which would
> cause any existing deployments of v11 to complain about the
> inconsistency.  I think that this should be fixed client-side as the
> attached does.

Thanks, looks good.  I propose to add following pg_dump test to ensure
this stays fixed.

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

Вложения

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

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: assert in nested SQL procedure call in current HEAD
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Cache invalidation after authentication (on-the-fly role creation)