Re: Potential G2-item cycles under serializable isolation - Mailing list pgsql-bugs

From Thomas Munro
Subject Re: Potential G2-item cycles under serializable isolation
Date
Msg-id CA+hUKGJrYxibcB6KRK779HgoOQZy1oc6CxeYXdMr0SeM+OYZkg@mail.gmail.com
Whole thread Raw
In response to Re: Potential G2-item cycles under serializable isolation  (Peter Geoghegan <pg@bowt.ie>)
Responses Re: Potential G2-item cycles under serializable isolation
List pgsql-bugs
On Tue, Jun 9, 2020 at 2:08 PM Peter Geoghegan <pg@bowt.ie> wrote:
> On Mon, Jun 8, 2020 at 7:01 PM Thomas Munro <thomas.munro@gmail.com> wrote:
> > Right, the only change was to move things around a bit to suport new
> > table AMs.  Speaking of which, it looks like the new comment atop
> > CheckForSerializableConflictOut() could use some adjustment.  It says
> > "A table AM is reading a tuple that has been modified.  After
> > determining that it is visible to us, it should call this function..."
> > but it seems the truth is a bit more complicated than that.
>
> Right. I think that you can go ahead and change it without further input here.

It's only comments, but it'd still be good to get some review since
it's essentially describing the relevant contract.  Here's what I came
up with.

Attachment

pgsql-bugs by date:

Previous
From: Daniel Gustafsson
Date:
Subject: Re: BUG #16484: pg_regress fails with --outputdir parameter
Next
From: Tom Lane
Date:
Subject: Re: pg_stat_statements: duplicated external query texts with MSY2