Re: Do postgres use implicit transaction in UPDATE ... RETURNING queries?

Поиск
Список
Период
Сортировка
От Laurenz Albe
Тема Re: Do postgres use implicit transaction in UPDATE ... RETURNING queries?
Дата
Msg-id bee328cdbb76d906d949b40bece16f4372be4604.camel@cybertec.at
обсуждение исходный текст
Ответ на Re: Do postgres use implicit transaction in UPDATE ... RETURNING queries?  (Peter Gram <peter.m.gram@gmail.com>)
Список pgsql-admin
On Fri, 2024-11-29 at 13:39 +0100, Peter Gram wrote:
> I would like to say in this way : Many clients like psql set autocommit on as default. 
> It is up to the client to define the default and there are clients that default to autocommit off.

The server is always in autocommit mode.

Clients can fake "autocommit off" by tacitly sending transaction control statements.

Yours,
Laurenz Albe



В списке pgsql-admin по дате отправления: