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

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)