public inbox for [email protected]  

help / color / mirror / Atom feed

From: Kyle Kingsbury <[email protected]>
To: Andrey Borodin <[email protected]>
Cc: PostgreSQL mailing lists <[email protected]>
Subject: Re: Possible G2-item at SERIALIZABLE
Date: Sun, 31 May 2026 20:49:47 -0500
Message-ID: <[email protected]> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
	<[email protected]>

On 5/31/26 08:19, Andrey Borodin wrote:
> Could you confirm whether you still observe G2-item anomalies with a server
> configured default_transaction_isolation = 'serializable' (so that the
> single-statement operations are certainly Serializable)? If they persist under that
> setting I'll dig further...

<sigh>

Yes, this was it, thank you. I've been reworking a whole bunch of things 
to make these tests portable between DBs and totally lost the 
session-wide transaction isolation. This behavior disappears with:

SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL SERIALIZABLE;

Thank you kindly, Andrey. :-)

--Kyle

view thread (10+ messages)  latest in thread

reply

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: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: Possible G2-item at SERIALIZABLE
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox