Cannot dump foreign key constraints on partitioned table

Поиск
Список
Период
Сортировка
От amul sul
Тема Cannot dump foreign key constraints on partitioned table
Дата
Msg-id CAAJ_b94n=UsNVhgs97vCaWEZAMe-tGDRVuZ73oePQH=eaJKGSA@mail.gmail.com
обсуждение исходный текст
Ответы Re: Cannot dump foreign key constraints on partitioned table  (Michael Paquier <michael@paquier.xyz>)
Список pgsql-hackers
Hi,

On the master head, getConstraints() function skips FK constraints for
a partitioned table because of tbinfo->hastriggers is false.

While creating FK constraints on the partitioned table, the FK triggers are only
created on leaf partitions and skipped for the partitioned tables.

To fix this, either bypass the aforementioned condition of getConstraints() or
set pg_class.relhastriggers to true for the partitioned table which doesn't seem
to be the right solution, IMO.  Thoughts?

Regards,
Amul


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

Предыдущее
От: Ashutosh Bapat
Дата:
Сообщение: partition pruning doesn't work with IS NULL clause in multikey rangepartition case
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Negotiating the SCRAM channel binding type