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

Tom Lane <tgl@sss.pgh.pa.us>

From: Tom Lane <tgl@sss.pgh.pa.us>

To: Álvaro Herrera <alvherre@alvh.no-ip.org>

Cc: Amul Sul <sulamul@gmail.com>, "pgsql-hackers@lists.postgresql.org" <pgsql-hackers@lists.postgresql.org>

Date: 2025-01-24T02:16:46Z

Lists: pgsql-hackers

=?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

Commits

Add missing CommandCounterIncrement
- 0a16c8326c5a 18.0 landed
Fix instability in recently added regression tests
- c44c2d275987 18.0 landed
Allow NOT VALID foreign key constraints on partitioned tables
- b663b9436e75 18.0 landed
Split ATExecValidateConstraint into reusable pieces
- 86374c9a0e30 18.0 landed