Re: BUG #18628: Race condition during attach/detach partition breaks constraints of partition having foreign key
| От | Tender Wang |
|---|---|
| Тема | Re: BUG #18628: Race condition during attach/detach partition breaks constraints of partition having foreign key |
| Дата | |
| Msg-id | CAHewXNk3NcN6-EtB9brCsW_ps_GZHztGmveTUPuZvrgBz75-HA@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: BUG #18628: Race condition during attach/detach partition breaks constraints of partition having foreign key (Alexander Lakhin <exclusion@gmail.com>) |
| Ответы |
Re: BUG #18628: Race condition during attach/detach partition breaks constraints of partition having foreign key
|
| Список | pgsql-bugs |
Alexander Lakhin <exclusion@gmail.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.
В списке pgsql-bugs по дате отправления: