Postgres Pro
Downloads
Home   >   mailing lists

Re: handling multiple matching constraints in DetachPartitionFinalize() - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: handling multiple matching constraints in DetachPartitionFinalize()
Date
Msg-id 20220823181003.4py5qycf66kwop2w@alvherre.pgsql
Whole thread Raw
In response to Re: handling multiple matching constraints in DetachPartitionFinalize()  (Zhihong Yu <zyu@yugabyte.com>)
List pgsql-hackers
Tree view 
On 2022-Aug-23, Zhihong Yu wrote:

> 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.

Well, let's see it in action.

-- 
Álvaro Herrera        Breisgau, Deutschland  —  https://www.EnterpriseDB.com/

pgsql-hackers by date:

Previous
From: Nathan Bossart
Date:
Subject: Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work
Next
From: Andrew Dunstan
Date:
Subject: Re: SQL/JSON features for v15