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

Amul Sul <sulamul@gmail.com>

From: Amul Sul <sulamul@gmail.com>
To: Álvaro Herrera <alvherre@alvh.no-ip.org>
Cc: Alexander Lakhin <exclusion@gmail.com>, "pgsql-hackers@lists.postgresql.org" <pgsql-hackers@lists.postgresql.org>
Date: 2025-01-28T03:39:18Z
Lists: pgsql-hackers
On Sun, Jan 26, 2025 at 10:08 PM Álvaro Herrera <alvherre@alvh.no-ip.org> wrote:
>
> On 2025-Jan-25, Álvaro Herrera wrote:
>
> > On Sat, Jan 25, 2025, at 6:00 AM, Alexander Lakhin wrote:
> > > Hello Álvaro,
> > >
> > > Please look at the script that produces an error starting from b663b9436:
> >
> > Ah yes, this is my bug: I moved a CCI where it became conditional.
> > Will fix, thanks for the test case.
>
> Pushed the fix, thanks.
>

Thank you !

Regards,
Amul



Commits

  1. Add missing CommandCounterIncrement

  2. Fix instability in recently added regression tests

  3. Allow NOT VALID foreign key constraints on partitioned tables

  4. Split ATExecValidateConstraint into reusable pieces