MIME-Version: 1.0
Message-ID: 
 <trinity-cf9ddf31-623c-4512-beff-cf6d6d0116b8-1634205902640@3c-app-gmx-bs43>
From: Karsten Hilbert <Karsten.Hilbert@gmx.net>
To: Daniel Fortunov <postgresql@danielfortunov.com>
Cc: Daniele Varrazzo <daniele.varrazzo@gmail.com>, Paolo De Stefani
 <paolo@paolodestefani.it>, Psycopg <psycopg@postgresql.org>
Subject: Aw: Re: psycopg3 transactions
Content-Type: text/plain; charset=UTF-8
Date: Thu, 14 Oct 2021 12:05:03 +0200
Importance: normal
Sensitivity: Normal
In-Reply-To: 
 <CAH1rg6ZoQm=STwMR6AQ_FggxRxUn7qH_tLkRTfJTVYYdbTeL6w@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>
 <CAH1rg6ZoQm=STwMR6AQ_FggxRxUn7qH_tLkRTfJTVYYdbTeL6w@mail.gmail.com>
Archived-At: 
 <https://www.postgresql.org/message-id/trinity-cf9ddf31-623c-4512-beff-cf6d6d0116b8-1634205902640%403c-app-gmx-bs43>
Precedence: bulk

>My conclusion is that the only sane thing to do is:
>1. Only ever create connections in autocommit mode.
>2. Only ever use `with connection.transaction()` to control transactions.
>3. Forget that `connection.commit()` and `connection.rollback()` exist, and never use them.

What if you need to rollback a hitherto valid transaction ?

Transactions are there for a reason. It seems best to explicitely use them ?

Karsten