Re: Re: BUG #19070: issue with DETACH PARTITION CONCURRENTLY on a hash partition table

From: Álvaro Herrera <alvherre(at)kurilemu(dot)de>
To: ocean_li_996 <ocean_li_996(at)163(dot)com>
Cc: "mohen(dot)lhy(at)alibaba-inc(dot)com" <mohen(dot)lhy(at)alibaba-inc(dot)com>, "pgsql-bugs(at)lists(dot)postgresql(dot)org" <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: Re: BUG #19070: issue with DETACH PARTITION CONCURRENTLY on a hash partition table
Date: 2025-10-11 18:34:18
Message-ID: 202510111831.xmk4a6jrtrqm@alvherre.pgsql
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On 2025-Oct-11, ocean_li_996 wrote:

> Based on the discussion in #18371 and my own investigation, I think the
> proposed fix is appropriate. I’m attaching patches for both the stable
> and master branches, FYI.

Yeah, looks good -- pushed to all branches since 14. One thing I
modified in branch master is that the test just above the new one is
testing that a constraint is being added, but that's no longer true, so
I removed some lines there.

--
Álvaro Herrera 48°01'N 7°57'E — https://www.EnterpriseDB.com/
"El número de instalaciones de UNIX se ha elevado a 10,
y se espera que este número aumente" (UPM, 1972)

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Álvaro Herrera 2025-10-11 18:35:36 Re: BUG #18371: There are wrong constraint residues when detach hash partiton concurrently
Previous Message Xuneng Zhou 2025-10-11 12:32:05 Re: BUG #19006: Assert(BufferIsPinned) in BufferGetBlockNumber() is triggered for forwarded buffer