Re: BUG #17893: Assert failed in heap_update()/_delete() when FK modiified by RI trigger in non-read-committed xact

From: Heikki Linnakangas <hlinnaka(at)iki(dot)fi>
To: Alexander Lakhin <exclusion(at)gmail(dot)com>, pgsql-bugs(at)lists(dot)postgresql(dot)org, Andres Freund <andres(at)anarazel(dot)de>
Subject: Re: BUG #17893: Assert failed in heap_update()/_delete() when FK modiified by RI trigger in non-read-committed xact
Date: 2023-11-28 10:39:09
Message-ID: fa4b0c02-8ba2-40b2-baf1-85d56469ab94@iki.fi
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On 28/11/2023 11:00, Alexander Lakhin wrote:
> 27.11.2023 22:23, Heikki Linnakangas wrote:
>> I propose to attached slight variation, which moves the assertions before the crosscheck snapshot check. The
>> assertions are correct as they are, if you don't need to take the crosscheck into account.
>
> Thank you for paying attention to this!
> I agree with your variation, it's more accurate.

Committed and backpatched. Thank you!

--
Heikki Linnakangas
Neon (https://neon.tech)

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Sri Mrudula Attili 2023-11-28 14:57:52 Re: Could not read from file "pg_subtrans/00F5" at offset 122880: Success.
Previous Message Alexander Lakhin 2023-11-28 09:00:00 Re: BUG #17893: Assert failed in heap_update()/_delete() when FK modiified by RI trigger in non-read-committed xact