Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1tGxxA-0026AP-PN
	for pgsql-admin@arkaria.postgresql.org; Fri, 29 Nov 2024 10:10:24 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1tGxx8-0068fo-7r
	for pgsql-admin@arkaria.postgresql.org; Fri, 29 Nov 2024 10:10:23 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <laurenz.albe@cybertec.at>)
	id 1tGxx7-0068fg-S2
	for pgsql-admin@lists.postgresql.org; Fri, 29 Nov 2024 10:10:23 +0000
Received: from mail-ej1-x62b.google.com ([2a00:1450:4864:20::62b])
	by makus.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256
	(Exim 4.94.2)
	(envelope-from <laurenz.albe@cybertec.at>)
	id 1tGxx6-0009Be-MH
	for pgsql-admin@postgresql.org; Fri, 29 Nov 2024 10:10:21 +0000
Received: by mail-ej1-x62b.google.com with SMTP id
 a640c23a62f3a-aa52bb7beceso173785266b.3
        for <pgsql-admin@postgresql.org>;
 Fri, 29 Nov 2024 02:10:20 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=cybertec.at; s=google; t=1732875018; x=1733479818;
 darn=postgresql.org;
        h=mime-version:user-agent:content-transfer-encoding:references
         :in-reply-to:date:to:from:subject:message-id:from:to:cc:subject:date
         :message-id:reply-to;
        bh=MokpxPsc9Jxqpl3IulygN3+ZOT7eqzCo8P2zuyr5giQ=;
        b=eoRrUcc3oUG2rQ+dmfStWI6ktITV9xA02ciLCU8Z1/Xun/1rirreQ0Fl32pnF8j3fw
         UIfrjFQu48VefPDqBLN0o5BM47CsYZ6mrvvclZrEzX2c7dLD1KQ0eO6cHowQm10C+Y3/
         m3C/Cr1Dr0lcPuSUVFbivngRVYt6Qbtu/QCjOFSJGqEk0unwg21riUEsjYdSlahDwVmT
         P8Lwr37JsGqRM5z4rT9uVnZ1W75q+twl2io+aBE9+46vKkmDFFO0Xq4oy1YIAXzRqkxP
         ItkQDnHTk+ye7yk+U+XtMYmB4vX5T6j2CcqN0XyxwlhuOQTYCyFXR5AY+cI+heTNwYVt
         BZDQ==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20230601; t=1732875018; x=1733479818;
        h=mime-version:user-agent:content-transfer-encoding:references
         :in-reply-to:date:to:from:subject:message-id:x-gm-message-state:from
         :to:cc:subject:date:message-id:reply-to;
        bh=MokpxPsc9Jxqpl3IulygN3+ZOT7eqzCo8P2zuyr5giQ=;
        b=J40nzAlZtDW3dYvO1CmFAfUThHcwOx/+BGRysbRnuwLNyH+tIPjzMB5HeLFQVHlgH7
         jhv1Kz80VQyWPEDMDDNWKGFAMGuUoWR3V+e9fnMdDuoZJhtBUICtu62PadfaZRPIOp9k
         LgDnb5JIYb1CX/9bcuWLh9qDSCqNDpCIF8tF/1p1zhBYoa3iNkjE9DKe/6Zuf8rBJXXS
         5qfCoU8YaUN0BAMGtfHksH6CtaC0XgDY1s+v7BLHpJzm4oa5i66AnSoEMv3guF7snXY6
         twq0g1DHkSfETcftiEPkdLBhPUgnP7BEf44yYDK7Ia48Fm4sfR9ACe5jRsiEZfrMaD49
         07mA==
X-Forwarded-Encrypted: i=1;
 AJvYcCX3lhwo7X78nWouqdMm2YlYc912nEE4ZFE8NEUCxI6Wk1jvhCiCpvonTJenj1LmKe2DIuQjhDS9WoXGSQ==@postgresql.org
X-Gm-Message-State: AOJu0YwlcJnueU2YzmHasZ+3P4MyrWvlnGE0h/yHIK6l0hXVYxmQYHNe
	uKVCd4OZJmsU+tyn9T891rdiTEgNEwMO9c08MN2ty4rgYwBJOcFtUrozb8MCE5A=
X-Gm-Gg: ASbGnctmPzHtOYzWXVGVAOFIHlVpEG0jZXo+5+KNoGRUdyFB9thwe2SlfJ0UymR9BaL
	GfxOyeS2NScT4kat3bgQVbzVpVWAQocD466hMx+0hqJt6gL4z6xL8Eirw6JjW5xrmEahaPUB1s2
	eTvnKac2br7BC1s4U1jzoUXupddp+mZiD/LHx1osGeQ+sK31rrhcy6jbfEm6gqhaKVvJqoVIbCY
	+vhzOABhJ150Eoas9OyNBdAcoprq4j1hpzfqmcfMfZsMzRMZhRY3H3DdVb+0ryTbFo=
X-Google-Smtp-Source: 
 AGHT+IE6YKiu6NKrauME3XiVc+LB5hraxdIgf1yDrzVpocs5m8aPS9qwNRBxtaMcPcP+Bc6Aan/rGQ==
X-Received: by 2002:a17:906:bfea:b0:aa5:35a6:8dbc with SMTP id
 a640c23a62f3a-aa580ed0d3amr850974366b.7.1732875018125;
        Fri, 29 Nov 2024 02:10:18 -0800 (PST)
Received: from localhost.localdomain ([2001:871:5e:2012:f65:e169:ee9f:76d])
        by smtp.gmail.com with ESMTPSA id
 a640c23a62f3a-aa5998e6491sm157943566b.101.2024.11.29.02.10.17
        (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256);
        Fri, 29 Nov 2024 02:10:17 -0800 (PST)
Message-ID: <ce9ec8ff921dfeebc37b6e760d2649b67ea80e91.camel@cybertec.at>
Subject: Re: Do postgres use implicit transaction in UPDATE ... RETURNING
 queries?
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Debraj Manna <subharaj.manna@gmail.com>, pgsql-admin
	 <pgsql-admin@postgresql.org>
Date: Fri, 29 Nov 2024 11:10:16 +0100
In-Reply-To: 
 <CAF6DVKNEbSXLVOs=BBNxhQ_+pjQJL8uMrwx9GWHNyAZyvirvmA@mail.gmail.com>
References: 
	<CAF6DVKNEbSXLVOs=BBNxhQ_+pjQJL8uMrwx9GWHNyAZyvirvmA@mail.gmail.com>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
User-Agent: Evolution 3.52.4 (3.52.4-2.fc40) 
MIME-Version: 1.0
List-Id: <pgsql-admin.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-admin@lists.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-admin>
Archived-At: 
 <https://www.postgresql.org/message-id/ce9ec8ff921dfeebc37b6e760d2649b67ea80e91.camel%40cybertec.at>
Precedence: bulk

On Fri, 2024-11-29 at 15:35 +0530, Debraj Manna wrote:
> Can someone let me know if Postgres 15 uses implicit transactions for=C2=
=A0UPDATE...RETURNING=C2=A0queries?

Yes, PostgreSQL always uses autocommit.

Yours,
Laurenz Albe