Re: BUG #19070: issue with DETACH PARTITION CONCURRENTLY on a hash partition table - Mailing list pgsql-bugs

From Álvaro Herrera
Subject Re: BUG #19070: issue with DETACH PARTITION CONCURRENTLY on a hash partition table
Date
Msg-id 202510101057.2czghujtfz33@alvherre.pgsql
Whole thread Raw
In response to Re:BUG #19070: issue with DETACH PARTITION CONCURRENTLY on a hash partition table  (ocean_li_996 <ocean_li_996@163.com>)
Responses Re:Re: BUG #19070: issue with DETACH PARTITION CONCURRENTLY on a hash partition table
List pgsql-bugs
On 2025-Oct-10, ocean_li_996 wrote:

> Since there has been no update in this thread for a few days, I
> reached out to the primary committer for this functionality.

Yes, this is buggy, and has been reported previously (#18371).  I'll fix
it before the November minors, probably by removing the step of creating
the constraints during detach.  I think for stable branches I'll do that
only for hash partitioning, to avoid breaking workloads that might
depend on those constraints, but for branch master I'll do it for all
partitioning strategies.

> No offense meant; I’m simply interested in getting your perspective.

Yeah, I should have reacted sooner to the previous report of this bug.
No offense taken.

-- 
Álvaro Herrera        Breisgau, Deutschland  —  https://www.EnterpriseDB.com/
"Linux transformó mi computadora, de una `máquina para hacer cosas',
en un aparato realmente entretenido, sobre el cual cada día aprendo
algo nuevo" (Jaime Salinas)



pgsql-bugs by date:

Previous
From: Marco Boeringa
Date:
Subject: Re: Potential "AIO / io workers" inter-worker locking issue in PG18?
Next
From: Álvaro Herrera
Date:
Subject: Re: BUG #19082: Failing assert in index scan