Horton

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

Alvaro Herrera <alvherre@alvh.no-ip.org>

View thread View on postgr.es
From: Álvaro Herrera <alvherre@alvh.no-ip.org>
To: Alexander Lakhin <exclusion@gmail.com>, Amul Sul <sulamul@gmail.com>
Cc: "pgsql-hackers@lists.postgresql.org" <pgsql-hackers@lists.postgresql.org>
Date: 2025-01-26T16:38:30Z
Lists: pgsql-hackers 
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.

-- 
Álvaro Herrera         PostgreSQL Developer  —  https://www.EnterpriseDB.com/
"Hay quien adquiere la mala costumbre de ser infeliz" (M. A. Evans)

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