Re: psycopg3 transactions - Mailing list psycopg

From Karsten Hilbert
Subject Re: psycopg3 transactions
Date
Msg-id YWtSWe7xYua37Tnv@hermes.hilbert.loc
Whole thread Raw
In response to Re: psycopg3 transactions  (Adrian Klaver <adrian.klaver@aklaver.com>)
List psycopg
Am Thu, Oct 14, 2021 at 03:38:21PM -0700 schrieb Adrian Klaver:

> >I would certainly suggest that a context manager calls
> >.rollback() during teardown rather than .commit() -- the
> >context manager cannot know whether actions really are to
> >be committed, even if technically possible.
>
> If I'm following that option exists:
>
> https://www.psycopg.org/psycopg3/docs/api/connections.html#psycopg.Connection.transaction
>
> force_rollback (bool) – Roll back the transaction at the end of the block even if there
> were no error (e.g. to try a no-op process).

Yes, but I would argue that force_rollback=True should be the
default.

Best,
Karsten
--
GPG  40BE 5B0E C98E 1713 AFA6  5BC0 3BEA AC80 7D4F C89B



psycopg by date:

Previous
From: Daniele Varrazzo
Date:
Subject: Re: psycopg3 transactions
Next
From: Karsten Hilbert
Date:
Subject: Re: psycopg3 transactions