Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps
 (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <psycopg-owner+archive@lists.postgresql.org>)
	id 1mdbKx-0002Xv-Nq
	for psycopg@arkaria.postgresql.org; Thu, 21 Oct 2021 16:54:39 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.92)
	(envelope-from <psycopg-owner+archive@lists.postgresql.org>)
	id 1mdbKw-0001cd-NH
	for psycopg@arkaria.postgresql.org; Thu, 21 Oct 2021 16:54:38 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <xof@thebuild.com>)
	id 1mdbKw-0001cS-H6
	for psycopg@lists.postgresql.org; Thu, 21 Oct 2021 16:54:38 +0000
Received: from smtp73.ord1c.emailsrvr.com ([108.166.43.73])
	by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <xof@thebuild.com>)
	id 1mdbKu-0006La-53
	for psycopg@postgresql.org; Thu, 21 Oct 2021 16:54:38 +0000
X-Auth-ID: xof@thebuild.com
Received: by smtp10.relay.ord1c.emailsrvr.com (Authenticated sender:
 xof-AT-thebuild.com) with ESMTPSA id CA609402DB;
	Thu, 21 Oct 2021 12:54:33 -0400 (EDT)
Content-Type: text/plain;
	charset=us-ascii
Mime-Version: 1.0 (Mac OS X Mail 13.4 \(3608.120.23.2.7\))
Subject: Re: psycopg3 transactions
From: Christophe Pettus <xof@thebuild.com>
In-Reply-To: 
 <CABUevEx66T=81029hvDORpsSMDZcTmaQqKmBNcWu4KmQGYgT=w@mail.gmail.com>
Date: Thu, 21 Oct 2021 09:22:07 -0700
Cc: Karsten Hilbert <Karsten.Hilbert@gmx.net>,
 Paolo De Stefani <paolo@paolodestefani.it>,
 Magnus Hagander <magnus@hagander.net>,
 Daniele Varrazzo <daniele.varrazzo@gmail.com>
X-Mailbutler-Message-Id: A331ADC8-71AA-4E2A-9FE7-FCB2C1561B78
Content-Transfer-Encoding: quoted-printable
Message-Id: <1A345ABA-0509-46DF-900C-BA0296ADD5A9@thebuild.com>
References: <eb5cc5d20c520e32b5963a4044b70af1@paolodestefani.it>
 <CA+mi_8bXjHTrzDLQ+n_6K2MHVsr0J32X1HA28Ey9O+-Zm6JaeQ@mail.gmail.com>
 <9a99d2d110b121542d1ea0a05066858b@paolodestefani.it>
 <CA+mi_8afF2jMifiLSvL99+Ztupy1me7xDNAv0g47WxHWbwN9vw@mail.gmail.com>
 <6683df3e65fe961aa478e61db7ad687d@paolodestefani.it>
 <CA+mi_8ZJy5yHovbjBhevWLhm9b3RH67qD+_5Mk+trfb1-Z19jQ@mail.gmail.com>
 <CA+mi_8ZvfQ3ndZDrRFX1XCfMyGLhkp5ZVq4Y92iZe4nxtkw_Yw@mail.gmail.com>
 <YWtWyC/Ur+iqHTLv@hermes.hilbert.loc>
 <CA+mi_8bY1HJrAVrUFsdDCqJT4+UjK7i7Lfso4dN_0nNf7RU4nQ@mail.gmail.com>
 <trinity-b5bbbf6a-2f7d-4865-ad6b-3e846cf58399-1634814394835@3c-app-gmx-bap69>
 <CA+mi_8aK5UPGfBjxPYPkGKbHM+JWbqMAS5zCB7LECRDbRQrXHA@mail.gmail.com>
 <CABUevEx66T=81029hvDORpsSMDZcTmaQqKmBNcWu4KmQGYgT=w@mail.gmail.com>
To: Psycopg <psycopg@postgresql.org>
X-Mailer: Apple Mail (2.3608.120.23.2.7)
X-Classification-ID: 739bd78e-5c4d-4081-90c1-8861d4530684-1-1
List-Id: <psycopg.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:psycopg@lists.postgresql.org>
List-Owner: <mailto:psycopg-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/psycopg>
Archived-At: 
 <https://www.postgresql.org/message-id/1A345ABA-0509-46DF-900C-BA0296ADD5A9%40thebuild.com>
Precedence: bulk



> On Oct 21, 2021, at 09:18, Magnus Hagander <magnus@hagander.net> =
wrote:
> But yes, the biggest issue I have with it is the part that's outlined =
in the Warning section of the docs there -- using it in different ways =
provides completely and fundamentally different behaviour in a way that =
can cause bad data.
>=20
> Things would be a lot more clear if the *connection* context didn't do =
*anything* with transactions whatsoever, and the *transaction* one did =
all of it. When it comes to transactions, explicit is always better than =
implicit IMNSHO.

+1.  I have to say that had I not read the warning, the behavior would =
have taken me by surprise, even with a lot of psycopg2 experience.=