From: | Daniele Varrazzo <daniele(dot)varrazzo(at)gmail(dot)com> |
---|---|
To: | Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)net> |
Cc: | Paolo De Stefani <paolo(at)paolodestefani(dot)it>, Psycopg <psycopg(at)postgresql(dot)org> |
Subject: | Re: Re: psycopg3 transactions |
Date: | 2021-10-21 12:00:10 |
Message-ID: | CA+mi_8aK5UPGfBjxPYPkGKbHM+JWbqMAS5zCB7LECRDbRQrXHA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | psycopg |
On Thu, 21 Oct 2021 at 12:06, Karsten Hilbert <Karsten(dot)Hilbert(at)gmx(dot)net> wrote:
>
> > The behaviour of a dbapi connection, without context block, is to just close the communication. The fact that this results in a rollback > stems only from the behaviour of the server
>
> But that's the whole point? A driver should _not_ (by default) alter the default
> behaviour of the other end, IMO, without extremely good reason. There _is_ good
> reason for the transaction context manager, but not for the connection context
> manager or plain use.
The implicit BEGIN is also a surprising change from the "natural
course of events". Psycopg can still be used as a driver and not alter
the natural course of events. I have extended the documentation
(https://www.psycopg.org/psycopg3/docs/basic/usage.html#connection-context)
both highlighting the difference in behaviour you reported and
suggesting to not use 'with' in case more control is needed (using
psycopg more as a driver than as the end user).
> > asking that the program to 'conn.commit()' explicitly seems an unrequested, kinda ritual, final blessing.
>
> Exactly.
>
> > Sending an explicit ROLLBACK is an occurrence much more rare,
>
> Exactly, and thusly easily forgotten, with possibly dire consequences
> (in the case of default-commit, as opposed to default-rollback).
On this I disagree. People forget to do things when they are a
repetitive common occurrence, not when they are extraordinary.
I don't really see a disaster occurring there, especially because
porting code from psycopg2 results in pretty much the same operations.
-- Daniele
From | Date | Subject | |
---|---|---|---|
Next Message | Magnus Hagander | 2021-10-21 16:18:43 | Re: Re: psycopg3 transactions |
Previous Message | Karsten Hilbert | 2021-10-21 11:06:34 | Aw: Re: psycopg3 transactions |