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

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: Peter Gram <peter(dot)m(dot)gram(at)gmail(dot)com>
Cc: Debraj Manna <subharaj(dot)manna(at)gmail(dot)com>, pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Do postgres use implicit transaction in UPDATE ... RETURNING queries?
Date: 2024-11-29 13:09:31
Message-ID: bee328cdbb76d906d949b40bece16f4372be4604.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Erik Serrano 2024-12-02 16:34:33 Database disconnection due to timeout
Previous Message Peter Gram 2024-11-29 12:39:12 Re: Do postgres use implicit transaction in UPDATE ... RETURNING queries?