Feedback-ID: i76984098:Fastmail
Message-ID: <dcf7f34d-0f5e-4674-8a26-081dfff387c4@aklaver.com>
Date: Tue, 24 Sep 2024 09:16:50 -0700
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: Repeatable Read Isolation Level "transaction start time"
To: Ron Johnson <ronljohnsonjr@gmail.com>,
 "pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
References: <9CEBFAC7-4372-4FF0-8124-FFFE834B03C6@gmail.com>
 <CAKFQuwYvh02jtAAmybAPGC00k-AWiOqm3vT2Aj3m8dKLO+fugg@mail.gmail.com>
 <CANzqJaC0Puj0WnnjQ2K2qy1MQJY4O8QP5uJbNoqeQrhfdgJ8Xg@mail.gmail.com>
 <0d074fba-3cd1-466e-96f3-d9b2c9c45774@aklaver.com>
 <CANzqJaAdL0bwqabW-ttWvRM4WXYhJ1FTtK3zXZ0p9KdcjgM_9Q@mail.gmail.com>
Content-Language: en-US
From: Adrian Klaver <adrian.klaver@aklaver.com>
In-Reply-To: <CANzqJaAdL0bwqabW-ttWvRM4WXYhJ1FTtK3zXZ0p9KdcjgM_9Q@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Archived-At: <https://www.postgresql.org/message-id/dcf7f34d-0f5e-4674-8a26-081dfff387c4%40aklaver.com>
Precedence: bulk

On 9/24/24 09:12, Ron Johnson wrote:

> Makes sense.  Never would have occurred to me to try and change the 
> isolation level using a second SET TRANSACTION statement, though.

 From the docs:

https://www.postgresql.org/docs/current/sql-set-transaction.html

The SET TRANSACTION command sets the characteristics of the current 
transaction. It has no effect on any subsequent transactions. SET 
SESSION CHARACTERISTICS sets the default transaction characteristics for 
subsequent transactions of a session. These defaults can be overridden 
by SET TRANSACTION for an individual transaction.


> 
> -- 
> Death to <Redacted>, and butter sauce.
> Don't boil me, I'm still alive.
> <Redacted> crustacean!

-- 
Adrian Klaver
adrian.klaver@aklaver.com