Postgres Pro
Downloads
Home   >   mailing lists

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

From Laurenz Albe
Subject Re: Do postgres use implicit transaction in UPDATE ... RETURNING queries?
Date
Msg-id bee328cdbb76d906d949b40bece16f4372be4604.camel@cybertec.at
Whole thread Raw
In response to Re: Do postgres use implicit transaction in UPDATE ... RETURNING queries?  (Peter Gram <peter.m.gram@gmail.com>)
List pgsql-admin
Tree view 
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 by date:

Previous
From: Peter Gram
Date:
Subject: Re: Do postgres use implicit transaction in UPDATE ... RETURNING queries?
Next
From: Erik Serrano
Date:
Subject: Database disconnection due to timeout