Обсуждение: Re: Allow NOT VALID foreign key constraints on partitioned tables.

Поиск
Список
Период
Сортировка

Re: Allow NOT VALID foreign key constraints on partitioned tables.

От
Álvaro Herrera
Дата:
On 2025-Jan-22, Amul Sul wrote:

> You’re correct; it’s fixed in the attached version, along with an
> assert(!convalidated) in QueueFKConstraintValidation(), and I’ve
> included tests to cover the change. Thanks for reviewing this patch.

OK thanks, looks good, I have pushed it now with some trivial
amendments.

-- 
Álvaro Herrera         PostgreSQL Developer  —  https://www.EnterpriseDB.com/
"Java is clearly an example of money oriented programming"  (A. Stepanov)



Re: Allow NOT VALID foreign key constraints on partitioned tables.

От
Tom Lane
Дата:
=?utf-8?Q?=C3=81lvaro?= Herrera <alvherre@alvh.no-ip.org> writes:
> OK thanks, looks good, I have pushed it now with some trivial
> amendments.

Looks like some of the queries need ORDER BY for stability.

https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=morepork&dt=2025-01-23%2023%3A35%3A57

            regards, tom lane