Postgres Pro
Downloads
Home   >   mailing lists

Re: Who adds the "start transaction" and "commit" to the intended SQL statement in "autocommit" mode? - Mailing list pgsql-general

From Christophe Pettus
Subject Re: Who adds the "start transaction" and "commit" to the intended SQL statement in "autocommit" mode?
Date
Msg-id 01B79A01-67D0-4D0B-A30F-9B9C2348342E@thebuild.com
Whole thread Raw
In response to Who adds the "start transaction" and "commit" to the intended SQL statement in "autocommit" mode?  (Bryn Llewellyn <bryn@yugabyte.com>)
List pgsql-general
Tree view 

> On Feb 18, 2023, at 15:49, Bryn Llewellyn <bryn@yugabyte.com> wrote:
>
> Or is it done server-side?

It's done server-side.  Note that what really happens is that, when a statement begins execution and there is no open
transaction,a snapshot is taken and then released when the statement finishes (just as happens in READ COMMITTED mode).
No piece of code literally injects a BEGIN and a COMMIT statement to make it happen.

pgsql-general by date:

Previous
From: Julien Rouhaud
Date:
Subject: Re: Who adds the "start transaction" and "commit" to the intended SQL statement in "autocommit" mode?
Next
From: Christophe Pettus
Date:
Subject: Re: Who adds the "start transaction" and "commit" to the intended SQL statement in "autocommit" mode?