Re: ALTER TABLE validate foreign key dependency problem

Поиск
Список
Период
Сортировка
От David Rowley
Тема Re: ALTER TABLE validate foreign key dependency problem
Дата
Msg-id CAApHDvrQ2UoEvxCb8-3G1xRXVbJp+qe5sfeUuKoSV+oVMXwJ4Q@mail.gmail.com
обсуждение исходный текст
Ответ на ALTER TABLE validate foreign key dependency problem  (David Rowley <dgrowleyml@gmail.com>)
Ответы Re: ALTER TABLE validate foreign key dependency problem  (Simon Riggs <simon@2ndquadrant.com>)
Список 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

Вложения

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Default setting for enable_hashagg_disk
Следующее
От: "David G. Johnston"
Дата:
Сообщение: Re: Default setting for enable_hashagg_disk