Horton

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

Heikki Linnakangas <hlinnaka@iki.fi>

View thread View on postgr.es
From: Heikki Linnakangas <hlinnaka@iki.fi>
To: Alexander Lakhin <exclusion@gmail.com>, pgsql-bugs@lists.postgresql.org, Andres Freund <andres@anarazel.de>
Date: 2023-11-28T10:39:09Z
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)

Commits

  1. Fix assertions with RI triggers in heap_update and heap_delete.