public inbox for [email protected]
help / color / mirror / Atom feedFrom: Adrian Klaver <[email protected]>
To: Ron Johnson <[email protected]>
To: [email protected] <[email protected]>
Subject: Re: Repeatable Read Isolation Level "transaction start time"
Date: Tue, 24 Sep 2024 09:16:50 -0700
Message-ID: <[email protected]> (raw)
In-Reply-To: <CANzqJaAdL0bwqabW-ttWvRM4WXYhJ1FTtK3zXZ0p9KdcjgM_9Q@mail.gmail.com>
References: <[email protected]>
<CAKFQuwYvh02jtAAmybAPGC00k-AWiOqm3vT2Aj3m8dKLO+fugg@mail.gmail.com>
<CANzqJaC0Puj0WnnjQ2K2qy1MQJY4O8QP5uJbNoqeQrhfdgJ8Xg@mail.gmail.com>
<[email protected]>
<CANzqJaAdL0bwqabW-ttWvRM4WXYhJ1FTtK3zXZ0p9KdcjgM_9Q@mail.gmail.com>
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
[email protected]
view thread (4+ messages)
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: Repeatable Read Isolation Level "transaction start time"
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