Content-Type: text/plain;
	charset=us-ascii
Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3776.700.51\))
Subject: Re: Repeatable Read Isolation Level "transaction start time"
From: Christophe Pettus <xof@thebuild.com>
In-Reply-To: <CAKAnmmL05Lt89EOnMW111qdUOau+dYG7u8ff5o+ckKKohnNwGg@mail.gmail.com>
Date: Wed, 25 Sep 2024 13:53:30 -0700
Cc: Ron Johnson <ronljohnsonjr@gmail.com>,
 "pgsql-generallists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Transfer-Encoding: quoted-printable
Message-Id: <DD2C10F3-2A3C-44AB-AAC5-10BB15B15498@thebuild.com>
References: <9CEBFAC7-4372-4FF0-8124-FFFE834B03C6@gmail.com>
 <3346993.1727188126@sss.pgh.pa.us>
 <CAKAnmmLt2ezcf7-LgJkO_oeqK+Ei+XB6F3pHk2mnyadRq3corQ@mail.gmail.com>
 <e9dba83f-0fba-4113-a13a-58aa2a98f092@aklaver.com>
 <CANzqJaBjwtzLg_bZHkokUJbtA8gy6RpHjirfdBH9OJGfn5=tmw@mail.gmail.com>
 <28109.1727286817@sss.pgh.pa.us>
 <CAKAnmmLDpwgqu071t_Q7Fq349dYAgQim1x46U1DCAiiTcUmU2A@mail.gmail.com>
 <CANzqJaAAQFD_JvK=ChmfdGCRNP0G5gMtVBgF52bZiFjQxH8N_Q@mail.gmail.com>
 <CAKAnmmL05Lt89EOnMW111qdUOau+dYG7u8ff5o+ckKKohnNwGg@mail.gmail.com>
To: Greg Sabino Mullane <htamfids@gmail.com>
Archived-At: <https://www.postgresql.org/message-id/DD2C10F3-2A3C-44AB-AAC5-10BB15B15498%40thebuild.com>
Precedence: bulk


> On Sep 25, 2024, at 13:49, Greg Sabino Mullane <htamfids@gmail.com> =
wrote:
> BEGIN   ISOLATION MODE REPEATABLE READ   SNAPSHOT NOW;

This might well be a failure of imagination on my part, but when would =
it pragmatically matter that the snapshot is taken at the first =
statement as opposed to at BEGIN?=