Re: Repeatable Read Isolation Level "transaction start time" - Mailing list pgsql-general

From Greg Sabino Mullane
Subject Re: Repeatable Read Isolation Level "transaction start time"
Date
Msg-id CAKAnmmLDpwgqu071t_Q7Fq349dYAgQim1x46U1DCAiiTcUmU2A@mail.gmail.com
Whole thread Raw
In response to Re: Repeatable Read Isolation Level "transaction start time"  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Repeatable Read Isolation Level "transaction start time"
List pgsql-general
On Wed, Sep 25, 2024 at 1:53 PM Tom Lane <tgl@sss.pgh.pa.us> wrote:
Because we're not going to analyze the statement in the amount of depth needed to make that distinction before we crank up the
transactional machinery.  If it says SELECT, it gets a snapshot.

Ok, thanks. So to the original poster's point, perhaps the path with the least side effects / best Principle of Least Surprise (POLS) support is to start the transaction, and immediately call a "SELECT 1;" or perhaps better still, a 'SELECT timeofday();'

Cheers,
Greg

pgsql-general by date:

Previous
From: Ron Johnson
Date:
Subject: Re: Repeatable Read Isolation Level "transaction start time"
Next
From: Ron Johnson
Date:
Subject: Re: Repeatable Read Isolation Level "transaction start time"