public inbox for [email protected]
help / color / mirror / Atom feedFrom: Christophe Pettus <[email protected]>
To: Psycopg <[email protected]>
Cc: Karsten Hilbert <[email protected]>
Cc: Paolo De Stefani <[email protected]>
Cc: Magnus Hagander <[email protected]>
Cc: Daniele Varrazzo <[email protected]>
Subject: Re: psycopg3 transactions
Date: Thu, 21 Oct 2021 09:22:07 -0700
Message-ID: <[email protected]> (raw)
In-Reply-To: <CABUevEx66T=81029hvDORpsSMDZcTmaQqKmBNcWu4KmQGYgT=w@mail.gmail.com>
References: <[email protected]>
<CA+mi_8bXjHTrzDLQ+n_6K2MHVsr0J32X1HA28Ey9O+-Zm6JaeQ@mail.gmail.com>
<[email protected]>
<CA+mi_8afF2jMifiLSvL99+Ztupy1me7xDNAv0g47WxHWbwN9vw@mail.gmail.com>
<[email protected]>
<CA+mi_8ZJy5yHovbjBhevWLhm9b3RH67qD+_5Mk+trfb1-Z19jQ@mail.gmail.com>
<CA+mi_8ZvfQ3ndZDrRFX1XCfMyGLhkp5ZVq4Y92iZe4nxtkw_Yw@mail.gmail.com>
<YWtWyC/[email protected]>
<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>
> On Oct 21, 2021, at 09:18, Magnus Hagander <[email protected]> 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.
>
> 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.
view thread (28+ messages)
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected], [email protected], [email protected]
Subject: Re: psycopg3 transactions
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox