Re: ALTER TABLE validate foreign key dependency problem - Mailing list pgsql-hackers

From David Rowley
Subject Re: ALTER TABLE validate foreign key dependency problem
Date
Msg-id CAApHDvrQ2UoEvxCb8-3G1xRXVbJp+qe5sfeUuKoSV+oVMXwJ4Q@mail.gmail.com
Whole thread Raw
In response to ALTER TABLE validate foreign key dependency problem  (David Rowley <dgrowleyml@gmail.com>)
Responses Re: ALTER TABLE validate foreign key dependency problem  (Simon Riggs <simon@2ndquadrant.com>)
List pgsql-hackers
On Thu, 9 Jul 2020 at 15:54, David Rowley <dgrowleyml@gmail.com> wrote:
> I think the fix is just to delay the foreign key validation when
> there's a rewrite pending until the rewrite is complete.

I looked over this again and only slightly reworded a comment.  The
problem exists as far back as 9.5 so I've attached 3 patches that,
pending any objections, I plan to push about 24 hours from now.

> I also considered that we could just delay all foreign key validations
> until phase 3, but I ended up just doing then only when a rewrite is
> pending.

I still wonder if it's best to delay the validation of the foreign key
regardless of if there's a pending table rewrite, but the patch as it
is now only delays if there's a pending rewrite.

David

Attachment

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Default setting for enable_hashagg_disk
Next
From: "David G. Johnston"
Date:
Subject: Re: Default setting for enable_hashagg_disk