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.kla...@aklaver.com



Reply via email to