Path: ...!eternal-september.org!feeder3.eternal-september.org!news.eternal-september.org!.POSTED!not-for-mail
From: Jon Ribbens <jon+usenet@unequivocal.eu>
Newsgroups: comp.lang.python
Subject: Re: psycopg2 positioning of .commit() (Posting On Python-List
 Prohibited)
Date: Mon, 9 Sep 2024 19:00:17 -0000 (UTC)
Organization: A noiseless patient Spider
Lines: 10
Message-ID: <slrnvduhe0.4dt.jon+usenet@raven.unequivocal.eu>
References: <Zty7ZCMwKQl4C4Id@hermes.hilbert.loc>
 <4a1b12fc-24b7-4c7e-b1f2-6ec9c5f341c2@aklaver.com>
 <ZtzDubguRDWXwV-t@hermes.hilbert.loc>
 <mailman.46.1725744071.2917.python-list@python.org>
 <lk4ajkFbbnrU1@mid.individual.net>
 <slrnvdr13p.4dt.jon+usenet@raven.unequivocal.eu>
 <vbl2ig$222n3$2@dont-email.me>
 <slrnvdtf24.4dt.jon+usenet@raven.unequivocal.eu>
 <vbmge5$2c7jr$1@dont-email.me>
 <slrnvdthpa.4dt.jon+usenet@raven.unequivocal.eu>
 <Zt8wd9ltA1hhU9F-@hermes.hilbert.loc>
 <mailman.3.1725902969.31645.python-list@python.org>
Injection-Date: Mon, 09 Sep 2024 21:00:17 +0200 (CEST)
Injection-Info: dont-email.me; posting-host="91f25785d594f1a8b1e061ab48225c7b";
	logging-data="2653044"; mail-complaints-to="abuse@eternal-september.org";	posting-account="U2FsdGVkX1924YxPTco6W4KFvYt7i8HNvfLfXH+m3dE="
User-Agent: slrn/1.0.3 (Linux)
Cancel-Lock: sha1:Vs16XiFzWWm026K2avF5dyuFN2o=
Bytes: 1913

On 2024-09-09, Karsten Hilbert <Karsten.Hilbert@gmx.net> wrote:
> Am Mon, Sep 09, 2024 at 10:00:11AM -0000 schrieb Jon Ribbens via Python-list:
>> So the Python code is half-way through a transaction when it throws
>> a (non-database-related) exception and that thread of execution is
>> aborted. The database connection returns to the pool,
>
> How does it return to the pool ?

It's just any circumstance in which a bit of your code uses a database
"cursor" (which isn't a cursor) that it didn't create moments before.