Postgres Pro
Downloads
Home   >   mailing lists

Re: Do postgres use implicit transaction in UPDATE ... RETURNING queries? - Mailing list pgsql-admin

From Peter Gram
Subject Re: Do postgres use implicit transaction in UPDATE ... RETURNING queries?
Date
Msg-id CAJ=80GVxXc+3amBZeG=0KknWijw=sxqNGvcsqq5X8u3ToaUeDg@mail.gmail.com
Whole thread Raw
In response to Re: Do postgres use implicit transaction in UPDATE ... RETURNING queries?  (Laurenz Albe <laurenz.albe@cybertec.at>)
Responses Re: Do postgres use implicit transaction in UPDATE ... RETURNING queries?
List pgsql-admin
Tree view
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 by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: Do postgres use implicit transaction in UPDATE ... RETURNING queries?
Next
From: Laurenz Albe
Date:
Subject: Re: Do postgres use implicit transaction in UPDATE ... RETURNING queries?