Re: handling multiple matching constraints in DetachPartitionFinalize()

Поиск
Список
Период
Сортировка
От Zhihong Yu
Тема Re: handling multiple matching constraints in DetachPartitionFinalize()
Дата
Msg-id CALNJ-vSBDzXfj-OU9g-HdquGCW0UoMRsyqR4LD7T-Y7ir9oNBQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: handling multiple matching constraints in DetachPartitionFinalize()  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Ответы Re: handling multiple matching constraints in DetachPartitionFinalize()
Список pgsql-hackers


On Tue, Aug 23, 2022 at 10:53 AM Alvaro Herrera <alvherre@alvh.no-ip.org> wrote:
On 2022-Aug-23, Zhihong Yu wrote:

> This is what I came up with.

I suggest you provide a set of SQL commands that provoke some wrong
behavior with the original code, and show that they generate good
behavior after the patch.  Otherwise, it's hard to evaluate the
usefulness of this.

--
Álvaro Herrera        Breisgau, Deutschland  —  https://www.EnterpriseDB.com/
"Puedes vivir sólo una vez, pero si lo haces bien, una vez es suficiente"

Toggling enable_seqscan on / off using the example from `parenting a PK constraint to a self-FK one` thread, it can be shown that different constraint Id would be detached which is incorrect.
However, I am not sure whether toggling enable_seqscan mid-test is legitimate.

Cheers

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

Предыдущее
От: Andrew Dunstan
Дата:
Сообщение: Re: SQL/JSON features for v15
Следующее
От: Nikita Glukhov
Дата:
Сообщение: Re: SQL/JSON features for v15