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

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: 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 10:10:16
Message-ID: ce9ec8ff921dfeebc37b6e760d2649b67ea80e91.camel@cybertec.at
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Peter Gram 2024-11-29 12:39:12 Re: Do postgres use implicit transaction in UPDATE ... RETURNING queries?
Previous Message Debraj Manna 2024-11-29 10:05:30 Do postgres use implicit transaction in UPDATE ... RETURNING queries?