On Sat, Feb 18, 2023 at 4:49 PM Bryn Llewellyn <bryn@xxxxxxxxxxxx> wrote:
And that the mode is a property of the current session.
To rephrase the other responses, the client-defined setting has no inherent relationship to the concept of a PostgreSQL session. How the client uses that setting is internal to the client and whatever abstraction(s) it provides the programmer.
So far as the server is concerned it is always auto (implicit) begin, and also auto (implicit) commit - absent receiving a BEGIN SQL Command in which case it disables implicit commit and (more or less) waits for a COMMIT or ROLLBACK before ending the transaction that it implicitly started.
David J.
