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

> On Feb 18, 2023, at 15:49, Bryn Llewellyn <bryn@yugabyte.com> wrote:
>
> I’ve searched in vain for an account of how "autocommit" mode actually works.

I realize now I may have misinterpreted your question... apologies if so!  If you mean the BEGIN and COMMIT statement
thatsome client libraries insert into the stream when autocommit is off, that's the client, not PostgreSQL. 

PostgreSQL has no idea that mode even exists: it either sees statements without transactions, which run in their own
transaction,or BEGIN / COMMIT statements.  Because client stacks have traditionally loved to provide their own
transactionsemantics, they might inject BEGIN and COMMIT statements, but that's not something PostgreSQL sees. 

(And I have never liked the term "autocommit mode"; it really doesn't reveal much about what is going on.