From: Heikki Linnakangas <hlinnaka@iki.fi>
To: Alexander Lakhin <exclusion@gmail.com>
To: pgsql-bugs@lists.postgresql.org, Andres Freund <andres@anarazel.de>
Subject: Re: BUG #17893: Assert failed in heap_update()/_delete() when FK modiified by RI trigger in non-read-committed xact
Date: Tue, 28 Nov 2023 12:39:09 +0200
Message-ID: <fa4b0c02-8ba2-40b2-baf1-85d56469ab94@iki.fi> (raw)
In-Reply-To: <8b695b41-a006-f4d2-545f-c99db7595ee2@gmail.com>
References: <17893-35847009eec517b5@postgresql.org>
<b77078c0-090c-0f0e-6f13-3bb7daca93ee@gmail.com>
<1236e144-d772-7ff4-6e23-4ce91d0923ad@gmail.com>
<0c6e10cd-9288-4dda-b35e-7a64684367d3@iki.fi>
<8b695b41-a006-f4d2-545f-c99db7595ee2@gmail.com>
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)
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: hlinnaka@iki.fi, exclusion@gmail.com, andres@anarazel.de
Subject: Re: BUG #17893: Assert failed in heap_update()/_delete() when FK modiified by RI trigger in non-read-committed xact
In-Reply-To: <fa4b0c02-8ba2-40b2-baf1-85d56469ab94@iki.fi>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox