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 1tH0kg-002VmB-3b
	for pgsql-admin@arkaria.postgresql.org; Fri, 29 Nov 2024 13:09:42 +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 1tH0kd-007fS6-Ff
	for pgsql-admin@arkaria.postgresql.org; Fri, 29 Nov 2024 13:09:40 +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 1tH0kd-007fRq-3j
	for pgsql-admin@lists.postgresql.org; Fri, 29 Nov 2024 13:09:40 +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 1tH0kc-000AT9-28
	for pgsql-admin@postgresql.org; Fri, 29 Nov 2024 13:09:39 +0000
Received: by mail-ej1-x62b.google.com with SMTP id
 a640c23a62f3a-aa52edbcb63so512050866b.1
        for <pgsql-admin@postgresql.org>;
 Fri, 29 Nov 2024 05:09:37 -0800 (PST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=cybertec.at; s=google; t=1732885776; x=1733490576;
 darn=postgresql.org;
        h=mime-version:user-agent:content-transfer-encoding:references
         :in-reply-to:date:cc:to:from:subject:message-id:from:to:cc:subject
         :date:message-id:reply-to;
        bh=5ILOEnR2LDvUMixIKRRoeiSH76XzHV3mKw0LeRipKAQ=;
        b=Rj0eGckT2+nXgyCLdB3DxeZAuueVjkkNg4iO26oRKQlHeDCb0c8FkR2fM5CbiB9Ly/
         7eU5l2+vuLiAvGomZcvcHXr/cNVmNBaXBX4hZmyQKdVT3Vd5MU9IWLPpahPK593pO8/5
         +QimtsAaGncP2KR57t15zGTqC/mQnj71oDmS1uTWUtGEKyJp+2GNcSa2zolQIb6aLTVS
         K4hcdH3p5fdmB7vaABmFdhonu77XJ8Zzszn3n67Aw1QB3GCc29ku8x5BOxR89kh149wa
         UZwq6XroQ7KPo11xcSqR03SJtSwcMA67pvi3XxTNPiZ1ZtK+YzTg9/YPY8T9tiSbi3EY
         oB0A==
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=1e100.net; s=20230601; t=1732885776; x=1733490576;
        h=mime-version:user-agent:content-transfer-encoding:references
         :in-reply-to:date:cc:to:from:subject:message-id:x-gm-message-state
         :from:to:cc:subject:date:message-id:reply-to;
        bh=5ILOEnR2LDvUMixIKRRoeiSH76XzHV3mKw0LeRipKAQ=;
        b=cG9vRfhsgpACMSU85C0XlvvbtAa+j5EpP38LUbfyHOmP6ODH60aQe+8b3W+8ISMeOL
         l5yCRJyH/ON0o1TT072MMHCROP8/lKiP++tZ+euRYsf+DcIlhVuMGIrsA5Ve/KfZLf/F
         TVcmrxS3/bV9FelqsFXR2B7rB80gKo4DiHSb9pZ62D82LStSPYI2aMQGofHL4OiH92dD
         8mdQroIiMD8aBbzEUgiOH5I+3Wt2JJqVjAtxEhmMvt3m310VJyDcAdjgHJ12hauvXQvm
         5xMjIZm8YudzHTHaKvEeYSERvcb5QrONbSuY/gkfE5FRVDLDyA3dsN5ta0dILuO/LDnt
         z1ZA==
X-Forwarded-Encrypted: i=1;
 AJvYcCWOGpwkL/ybHBohH9BL/g5464MtoYRceSVWc9Bs8oGSgnQtrCdlgRYKVvDuTM8oSZUBWQh9dDcIITh+sQ==@postgresql.org
X-Gm-Message-State: AOJu0YwaBiw7R0O1nSS1hEFHBy7sGCKTl+ALSkUHxHrySfmyA1b+Ynzs
	ng37NgKSh0oVFvRKqm4uaZ6EzlBtaq/TT8AilZb1JSmxLW/Vu/50V1q3a8N2778=
X-Gm-Gg: ASbGncv0i63JXTqLuPQu1K6lTVVPzN4PagooMRxRi9fmeGLIvd40Nw2irroEiot5pBw
	cbY3hl+p/h5+aOhgt6ahdYci5QtYacecGRPQRgv2bqArewaDqHljEd7DvfuJXeyoupr5ZJRLhGU
	vbPkhyIH0vbbhoWNag7tkpFkS9lpH8Z5CZQpGROlNH6Med0ZM22fX/6MudQOXS3Jp6nHEV7DkEs
	rqXtF4d/6NBgLqufYSRnH+8EY9E0Qm69zaO8r3s8HM+93Wk1hxmtPAmkiQ0Os839dkeXw==
X-Google-Smtp-Source: 
 AGHT+IFB83K0oFiajnDhOUUHBByhoGzQijKZPFuJoE5FsfRU1BpHw1hYdvGv312csmJMAEEzOiSwyA==
X-Received: by 2002:a17:906:d54b:b0:aa5:3fe7:4475 with SMTP id
 a640c23a62f3a-aa59453454fmr987894766b.11.1732885772311;
        Fri, 29 Nov 2024 05:09:32 -0800 (PST)
Received: from localhost.localdomain ([2001:871:5e:8581:696f:e756:1348:4da4])
        by smtp.gmail.com with ESMTPSA id
 a640c23a62f3a-aa599955e08sm172873666b.194.2024.11.29.05.09.31
        (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256);
        Fri, 29 Nov 2024 05:09:32 -0800 (PST)
Message-ID: <bee328cdbb76d906d949b40bece16f4372be4604.camel@cybertec.at>
Subject: Re: Do postgres use implicit transaction in UPDATE ... RETURNING
 queries?
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: Peter Gram <peter.m.gram@gmail.com>
Cc: Debraj Manna <subharaj.manna@gmail.com>, pgsql-admin
	 <pgsql-admin@postgresql.org>
Date: Fri, 29 Nov 2024 14:09:31 +0100
In-Reply-To: 
 <CAJ=80GVxXc+3amBZeG=0KknWijw=sxqNGvcsqq5X8u3ToaUeDg@mail.gmail.com>
References: 
	<CAF6DVKNEbSXLVOs=BBNxhQ_+pjQJL8uMrwx9GWHNyAZyvirvmA@mail.gmail.com>
	 <ce9ec8ff921dfeebc37b6e760d2649b67ea80e91.camel@cybertec.at>
	 <CAJ=80GVxXc+3amBZeG=0KknWijw=sxqNGvcsqq5X8u3ToaUeDg@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/bee328cdbb76d906d949b40bece16f4372be4604.camel%40cybertec.at>
Precedence: bulk

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 o=
n as default.=C2=A0
> It is up to the client to define the default and there are clients that d=
efault to autocommit off.

The server is always in autocommit mode.

Clients can fake "autocommit off" by tacitly sending transaction control st=
atements.

Yours,
Laurenz Albe