Re: Fix for a crash caused by triggers in cross-partition updates

2025-02-12 Thread Michael Paquier
On Fri, Feb 07, 2025 at 03:47:02PM +0900, Michael Paquier wrote: > Hmm.. Agreed, it seems that you are right in the way of taking care > of this inconsistency. That's interesting. I would need to look at > that more closely with a couple of hours head down. It's a bit late > in the week here so

Re: Fix for a crash caused by triggers in cross-partition updates

2025-02-06 Thread Michael Paquier
On Fri, Feb 07, 2025 at 03:02:38PM +0900, Kyotaro Horiguchi wrote: > We received a crash report related to cross-partition updates > involving multiple triggers. > > After investigating the situation, we found that the crash occurs by > the following steps in PostgreSQL versions 11 through 14 (We

Fix for a crash caused by triggers in cross-partition updates

2025-02-06 Thread Kyotaro Horiguchi
Hello. We received a crash report related to cross-partition updates involving multiple triggers. After investigating the situation, we found that the crash occurs by the following steps in PostgreSQL versions 11 through 14 (We have not checked versions 10 and earlier.): create table tp(a int) p