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

Поиск
Список
Период
Сортировка
От Peter Gram
Тема Re: Do postgres use implicit transaction in UPDATE ... RETURNING queries?
Дата
Msg-id CAJ=80GVxXc+3amBZeG=0KknWijw=sxqNGvcsqq5X8u3ToaUeDg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Do postgres use implicit transaction in UPDATE ... RETURNING queries?  (Laurenz Albe <laurenz.albe@cybertec.at>)
Ответы Re: Do postgres use implicit transaction in UPDATE ... RETURNING queries?
Список pgsql-admin
Дерево обсуждения
Hi Laurenz et al

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.

Med venlig hilsen

Peter Gram
Sæbyholmsvej 18 
2500 Valby

Mobile: (+45) 5374 7107



On Fri, 29 Nov 2024 at 11:10, Laurenz Albe <laurenz.albe@cybertec.at> wrote:
On Fri, 2024-11-29 at 15:35 +0530, Debraj Manna wrote:
> Can someone let me know if Postgres 15 uses implicit transactions for UPDATE...RETURNING queries?

Yes, PostgreSQL always uses autocommit.

Yours,
Laurenz Albe


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