Re: handling multiple matching constraints in DetachPartitionFinalize()

From: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To: Zhihong Yu <zyu(at)yugabyte(dot)com>
Cc: PostgreSQL Developers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: handling multiple matching constraints in DetachPartitionFinalize()
Date: 2022-08-23 18:10:03
Message-ID: 20220823181003.4py5qycf66kwop2w@alvherre.pgsql
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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/

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2022-08-23 18:10:59 Re: SQL/JSON features for v15
Previous Message Nathan Bossart 2022-08-23 18:07:44 Re: Avoid erroring out when unable to remove or parse logical rewrite files to save checkpoint work