Re: Who adds the "start transaction" and "commit" to the intended SQL statement in "autocommit" mode?

Поиск
Список
Период
Сортировка
От Christophe Pettus
Тема Re: Who adds the "start transaction" and "commit" to the intended SQL statement in "autocommit" mode?
Дата
Msg-id 01B79A01-67D0-4D0B-A30F-9B9C2348342E@thebuild.com
обсуждение исходный текст
Ответ на Who adds the "start transaction" and "commit" to the intended SQL statement in "autocommit" mode?  (Bryn Llewellyn <bryn@yugabyte.com>)
Список pgsql-general
Дерево обсуждения 

> 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 по дате отправления:

Предыдущее
От: Julien Rouhaud
Дата:
Сообщение: Re: Who adds the "start transaction" and "commit" to the intended SQL statement in "autocommit" mode?
Следующее
От: Christophe Pettus
Дата:
Сообщение: Re: Who adds the "start transaction" and "commit" to the intended SQL statement in "autocommit" mode?