Re: [BUG] Fix DETACH with FK pointing to a partitioned table fails
От | Jehan-Guillaume de Rorthais |
---|---|
Тема | Re: [BUG] Fix DETACH with FK pointing to a partitioned table fails |
Дата | |
Msg-id | 20240820102651.273ecdf5@karst обсуждение исходный текст |
Ответ на | Re: [BUG] Fix DETACH with FK pointing to a partitioned table fails (Alvaro Herrera <alvherre@alvh.no-ip.org>) |
Ответы |
Re: [BUG] Fix DETACH with FK pointing to a partitioned table fails
|
Список | pgsql-hackers |
On Wed, 7 Aug 2024 18:50:10 -0400 Alvaro Herrera <alvherre@alvh.no-ip.org> wrote: > On 2024-Jul-26, Tender Wang wrote: > > > Junwang Zhao <zhjwpku@gmail.com> 于2024年7月26日周五 14:57写道: > > > > > There is a bug report[0] Tender comments might be the same issue as > > > this one, but I tried Alvaro's and mine patch, neither could solve > > > that problem, I did not tried Tender's earlier patch thought. I post > > > the test script below in case you are interested. > > > > My earlier patch should handle Alexander reported case. But I did not > > do more test. I'm not sure that wether or not has dismatching between > > pg_constraint and pg_trigger. > > > > I aggred with Alvaro said that "requires a much more invasive > > solution". > > Here's the patch which, as far as I can tell, fixes all the reported > problems (other than the one in bug 18541, for which I proposed an > unrelated fix in that thread[1]). If you can double-check, I would very > much appreciate that. Also, I think the test cases the patch adds > reflect the provided examples sufficiently, but if we're still failing > to cover some, please let me know. I'm back on this issue as well. I start poking at this patch to review it, test it, challenge it and then report here. I'll try to check if some other issues might have lost/forgot on they way as well. In the meantime, thank you Alvaro, Tender and Junwang for your work, time, research and patches!
В списке pgsql-hackers по дате отправления: