Sujet : Re: psycopg2 positioning of .commit() (Posting On Python-List Prohibited)
De : ldo (at) *nospam* nz.invalid (Lawrence D'Oliveiro)
Groupes : comp.lang.pythonDate : 09. Sep 2024, 10:51:02
Autres entêtes
Organisation : A noiseless patient Spider
Message-ID : <vbmge5$2c7jr$1@dont-email.me>
References : 1 2 3 4 5 6 7 8 9 10 11 12
User-Agent : Pan/0.160 (Toresk; )
On Mon, 9 Sep 2024 09:13:40 -0000 (UTC), Jon Ribbens wrote:
On 2024-09-08, Lawrence D'Oliveiro <ldo@nz.invalid> wrote:
>
On Sun, 8 Sep 2024 11:03:21 -0000 (UTC), Jon Ribbens wrote:
>
What if there's an exception in your exception handler? I'd put the
rollback in the 'finally' handler, so it's always called. If you've
already called 'commit' then the rollback does nothing of course.
>
In any DBMS worth its salt, rollback is something that happens
automatically if the transaction should fail to complete for any
reason.
>
This applies for any failure reason, up to and including a program or
system crash.
If it's a program or system crash, sure, but anything less than that -
how would the database even know, unless the program told it?
The database only needs to commit when it is explicitly told. Anything
less -- no commit.
Re: psycopg2: proper positioning of .commit() within try: except: blocks
Re: psycopg2: proper positioning of .commit() within try: except: blocks