MIME-Version: 1.0
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>
In-Reply-To: <6683df3e65fe961aa478e61db7ad687d@paolodestefani.it>
From: Daniele Varrazzo <daniele.varrazzo@gmail.com>
Date: Wed, 13 Oct 2021 15:46:46 +0200
Message-ID: 
 <CA+mi_8Z2FT4bHN1yTiM=aS8BXkbiZLwP=KLasXGQPgBRoDPrMg@mail.gmail.com>
Subject: Re: psycopg3 transactions
To: Paolo De Stefani <paolo@paolodestefani.it>
Cc: Psycopg <psycopg@postgresql.org>
Content-Type: text/plain; charset="UTF-8"
Archived-At: 
 <https://www.postgresql.org/message-id/CA%2Bmi_8Z2FT4bHN1yTiM%3DaS8BXkbiZLwP%3DKLasXGQPgBRoDPrMg%40mail.gmail.com>
Precedence: bulk

On Wed, 13 Oct 2021 at 15:21, Paolo De Stefani <paolo@paolodestefani.it> wrote:

> I was used to wrote a "with con.cursor() as cur:" that now i hato to
> replace with:
>
> with con.transaction():
>      with con.cursor() as cur:
>          cur.execute("ANY SQL STATEMENT")
>
> and everything works as expected (or i expect...)

You can even write:

    with con.transaction():
        con.execute("ANY SQL STATEMENT")

But is it even useful to wrap a transaction around any single
statement? I still think you'd be better off with an autocommit
connection.

-- Daniele