| From: | Tender Wang <tndrwang(at)gmail(dot)com> |
|---|---|
| To: | Alexander Lakhin <exclusion(at)gmail(dot)com> |
| Cc: | Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>, pgsql-bugs(at)lists(dot)postgresql(dot)org |
| Subject: | Re: BUG #18628: Race condition during attach/detach partition breaks constraints of partition having foreign key |
| Date: | 2024-09-24 13:10:48 |
| Message-ID: | CAHewXNk3NcN6-EtB9brCsW_ps_GZHztGmveTUPuZvrgBz75-HA@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
Alexander Lakhin <exclusion(at)gmail(dot)com> 于2024年9月24日周二 20:00写道：
> 24.09.2024 14:23, Alvaro Herrera wrote:
> > I suspect this is the same problem that was reported by Jehan-Guillaume
> > de Rorthais, for which there are two patches proposed, his and mine:
> >
> > [1] https://postgr.es/m/202408072250.2c4fkhwf56lk@alvherre.pgsql
> > [2] https://postgr.es/m/20240905005728.0836d609@karst
> >
> > I haven't looked at his patch, but I suspect it's better than mine on
> > maintainability grounds. I think his code causes more catalog churn,
> > though perhaps we don't care too much about that in this particular
>
> Yes, v2-0001-Rework-foreign-key-....patch works for me — the partition
> detached with no error.
>
The Alvaro's version applied failure on HEAD because the fc0438b4e80 added
an argument to CreateConstraintEntry(). I fixed it. And I tested the patch
using your
providing script. No error again.
--
Thanks,
Tender Wang
https://www.openpie.com/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Fujii Masao | 2024-09-24 14:20:43 | Re: vacuumdb: permission denied for schema "pg_temp_7" |
| Previous Message | Alexander Lakhin | 2024-09-24 12:00:01 | Re: BUG #18628: Race condition during attach/detach partition breaks constraints of partition having foreign key |