MIME-Version: 1.0
Message-ID: 
 <trinity-b5bbbf6a-2f7d-4865-ad6b-3e846cf58399-1634814394835@3c-app-gmx-bap69>
From: Karsten Hilbert <Karsten.Hilbert@gmx.net>
To: Daniele Varrazzo <daniele.varrazzo@gmail.com>
Cc: Paolo De Stefani <paolo@paolodestefani.it>, Psycopg
 <psycopg@postgresql.org>
Subject: Aw: Re: psycopg3 transactions
Content-Type: text/plain; charset=UTF-8
Date: Thu, 21 Oct 2021 13:06:34 +0200
Importance: normal
Sensitivity: Normal
In-Reply-To: 
 <CA+mi_8bY1HJrAVrUFsdDCqJT4+UjK7i7Lfso4dN_0nNf7RU4nQ@mail.gmail.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>
Archived-At: 
 <https://www.postgresql.org/message-id/trinity-b5bbbf6a-2f7d-4865-ad6b-3e846cf58399-1634814394835%403c-app-gmx-bap69>
Precedence: bulk

> 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.

> I think that using 'execute("INSERT....")' is already quite a conscious decision of operating on the database.

I agree. But the decision is not "this IS to be in the database" (or else no need for
transactions) but rather "this is to be in the database IF other, perhaps not even
database related, things suceed".

> 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).

Karsten