| 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>, robertmhaas(at)gmail(dot)com |
| Subject: | Re: BUG #19070: issue with DETACH PARTITION CONCURRENTLY on a hash partition table |
| Date: | 2025-10-10 11:03:08 |
| Message-ID: | 202510101057.2czghujtfz33@alvherre.pgsql |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Álvaro Herrera | 2025-10-10 11:14:19 | Re: BUG #19082: Failing assert in index scan |
| Previous Message | Marco Boeringa | 2025-10-10 10:03:02 | Re: Potential "AIO / io workers" inter-worker locking issue in PG18? |