From: Álvaro Herrera <alvherre@kurilemu.de>
To: ocean_li_996 <ocean_li_996@163.com>
Cc: mohen.lhy@alibaba-inc.com <mohen.lhy@alibaba-inc.com>
Cc: pgsql-bugs@lists.postgresql.org <pgsql-bugs@lists.postgresql.org>
Cc: robertmhaas@gmail.com
Subject: Re: BUG #19070: issue with DETACH PARTITION CONCURRENTLY on a hash partition table
Date: Fri, 10 Oct 2025 13:03:08 +0200
Message-ID: <202510101057.2czghujtfz33@alvherre.pgsql> (raw)
In-Reply-To: <1831e120.1e8.199cc10d785.Coremail.ocean_li_996@163.com>
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)
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: alvherre@kurilemu.de, ocean_li_996@163.com, mohen.lhy@alibaba-inc.com, pgsql-bugs@lists.postgresql.org, robertmhaas@gmail.com
Subject: Re: BUG #19070: issue with DETACH PARTITION CONCURRENTLY on a hash partition table
In-Reply-To: <202510101057.2czghujtfz33@alvherre.pgsql>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox