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

[Peter Gram <peter.m.gram@xxxxxxxxx>]

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

Email: peter.m.gram@xxxxxxxxx

On Fri, 29 Nov 2024 at 11:10, Laurenz Albe <laurenz.albe@xxxxxxxxxxx> 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