| From: | Peter Gram <peter(dot)m(dot)gram(at)gmail(dot)com> |
|---|---|
| To: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
| 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 12:39:12 |
| Message-ID: | CAJ=80GVxXc+3amBZeG=0KknWijw=sxqNGvcsqq5X8u3ToaUeDg@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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(dot)m(dot)gram(at)gmail(dot)com
On Fri, 29 Nov 2024 at 11:10, Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)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
>
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Laurenz Albe | 2024-11-29 13:09:31 | Re: Do postgres use implicit transaction in UPDATE ... RETURNING queries? |
| Previous Message | Laurenz Albe | 2024-11-29 10:10:16 | Re: Do postgres use implicit transaction in UPDATE ... RETURNING queries? |