Deutsch English Français Italiano |
<mailman.3.1725902969.31645.python-list@python.org> View for Bookmarking (what is this?) Look up another Usenet article |
Path: ...!weretis.net!feeder9.news.weretis.net!feeder8.news.weretis.net!fu-berlin.de!uni-berlin.de!not-for-mail From: Karsten Hilbert <Karsten.Hilbert@gmx.net> Newsgroups: comp.lang.python Subject: Re: psycopg2 positioning of .commit() (Posting On Python-List Prohibited) Date: Mon, 9 Sep 2024 19:29:27 +0200 Lines: 12 Sender: <karsten.hilbert@gmx.net> Message-ID: <mailman.3.1725902969.31645.python-list@python.org> 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> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: quoted-printable X-Trace: news.uni-berlin.de erFIj2HbTIHERKk/e1CxeAf9Ewo+l19Qid9APieN7syg== Cancel-Lock: sha1:7hDtVF1XZhiJ4I++Rx0/NGgjB/Q= sha256:/0h+9jfVjw14rXuJiIwd9nlZjvNs7BzVixig5Ui2rs8= Return-Path: <karsten.hilbert@gmx.net> X-Original-To: python-list@python.org Delivered-To: python-list@mail.python.org Authentication-Results: mail.python.org; dkim=pass reason="2048-bit key; unprotected key" header.d=gmx.net header.i=karsten.hilbert@gmx.net header.b=TdSmvW6D; dkim-adsp=pass; dkim-atps=neutral X-Spam-Status: OK 0.031 X-Spam-Evidence: '*H*': 0.95; '*S*': 0.01; 'thread': 0.05; 'received:212.227': 0.07; 'gpg': 0.09; 'karsten': 0.09; 'schrieb': 0.09; 'subject:Python': 0.12; '1713': 0.16; '2024': 0.16; 'pool': 0.16; 'python': 0.16; 'to:addr:python-list': 0.20; 'exception': 0.22; 'returns': 0.22; 'code': 0.23; 'execution': 0.32; 'sep': 0.32; 'header:In-Reply-To:1': 0.34; 'mon,': 0.36; 'connection': 0.61; 'received:212': 0.62; 'received:91': 0.62; 'transaction': 0.64; 'subject:List': 0.71; 'database': 0.80; 'jon': 0.84; 'subject: \n ': 0.84; 'subject:Posting': 0.84 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmx.net; s=s31663417; t=1725902967; x=1726507767; i=karsten.hilbert@gmx.net; bh=mazSFoRhVcBIl0Ip/kC9IHYlj1FZXmgLjh0zU6HAJVA=; h=X-UI-Sender-Class:Date:From:To:Subject:Message-ID:References: MIME-Version:Content-Type:In-Reply-To:Content-Transfer-Encoding: cc:content-transfer-encoding:content-type:date:from:message-id: mime-version:reply-to:subject:to; b=TdSmvW6DeAGjTN9UYDQ2sfLXHWdhkYYv1jdUxpOfFMKUHBylmOJ+1S04fR3Nz0Qv hYH3duQqVZWgszOhtOmeh5S+jwk5ulYBQ3mxqnVehI+TmrTlxo+JOw+QBY3lSX2Fq HVaK/G2xCr63E+WvAu5aipYj8JjI6+e6RYN4/uU4H5wPFEdN3khxTFRplnuTbRvb2 GsvVhlBtU+YuXZKQItaTULjLNqskSluqRd70FuFp/kDT63ef8uaSlj/KoYSET/55D G0Gno0z8GW3Pma0cK9EG0fUJCw+8+KZNqnlyXmkEqkgvaQbhQdbkPuToZEBHi0J0i XPCYOF6UQdyg2h3ygQ== X-UI-Sender-Class: 724b4f7f-cbec-4199-ad4e-598c01a50d3a Content-Disposition: inline In-Reply-To: <slrnvdthpa.4dt.jon+usenet@raven.unequivocal.eu> Ma_X_il-Followup-to: d Re_X_turn-receipt-to: Karsten.Hilbert@gmx.net Di_X_sposition-Notification-To: Karsten.Hilbert@gmx.net X-Confi_X_rm-Reading-To: Karsten.Hilbert@gmx.net X-Pri_X_ority: 2 (High) X-Provags-ID: V03:K1:iMfjhIe4agvphxYgxHeY85UcB75JBurL+Jofyw8tPFtpY+oC3nA 1Ufq07BqUZr04fOUxKlqdpU2zmmBBXjcUxzI1/dRsJ7BtZ+LrOdE15sDNb6VxR5fumUJKOs qLaJvlUnKtIY0eKbteC9Yt6aCkCxhC8fbE9bCKSRmAdBCp6++3+80E0gwedoy5Q8nepi8au rEs/zVJBVbBZ+rHZpwAFQ== X-Spam-Flag: NO UI-OutboundReport: notjunk:1;M01:P0:xUTL3WnGMNs=;c88n+mGSiBJzZQUmVUg8Qj7sXQn d0G2B8jjR4GeTAKFTXL4zdDnykMM845yJhgfiVh8y4H4lD3i2BfRmZ+E3NIU7momedqb4R2jS z0tKWLlpRSDx/rLjZN2MYOFjwsQzAvu8P9QG7jlx3OzQc6Ylv423zTmLzlruXyYDFom5j8uHn PiRSGag86K9kkssHBnl6vVOJefgV+//tTTEgy+s8yrbDK3MiPtZUNtgUZ9rdVD65ZCO4W7VKJ qyIQoJoXoYgXCf/4yG8EFZgllERlTGS/Di+u1K9rgR+lU6pbaSRhiJnEBMsV+GlCi3+/DfgbH 5jaNBaYDhhaUaqYbIFqH99tgjG329hW36a+Surxb5TQj3itVLZ4iM1HrLnkhJ5VUegw2P0oc+ ikyKSwSlH5Cm0PoRzX5/jCDtxnt8jyjHKcSgxd3IF+Pk03/NtmotHc1hQujjmzsFXzyPdhNCL Y8FsUaz2AoZzKBiA8QZdDHgDd829mYhPTRHl1xUx2ocjRnXHgZFWMMcqeIbZh8vipDOkV4A3M UwnjI0xgvax8Cwjda+kionUyZw+jtL6NQwUkHQKSaCc0V8f6l1/Bxrid5VXmTkoXeVysUJjTt lVfzhEKAAxO/dNYdTa8XhlnY9Rji1zjvQLV/VXJ7JwN8V+0644wOlC/bRkfYZbyOHBTylUsnz AD1b64Z7l2TDgGhNZFpefvoQm7C4Tawjxm+oO1bNdVF0ZGPIQU+Tcy0JNvMB50GX+AiClTRmR w/WQ9SXeUmwusrSTvA32ZIsUYzljzayJSGmKLHGLp3dyHCy0V6s7s3bb0y2+lyLTNX1Vtu6KM QV9z9Gb104CgtmMUQx1IV+EQ== X-BeenThere: python-list@python.org X-Mailman-Version: 2.1.39 Precedence: list List-Id: General discussion list for the Python programming language <python-list.python.org> List-Unsubscribe: <https://mail.python.org/mailman/options/python-list>, <mailto:python-list-request@python.org?subject=unsubscribe> List-Archive: <https://mail.python.org/pipermail/python-list/> List-Post: <mailto:python-list@python.org> List-Help: <mailto:python-list-request@python.org?subject=help> List-Subscribe: <https://mail.python.org/mailman/listinfo/python-list>, <mailto:python-list-request@python.org?subject=subscribe> X-Mailman-Original-Message-ID: <Zt8wd9ltA1hhU9F-@hermes.hilbert.loc> X-Mailman-Original-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> Bytes: 6068 Am Mon, Sep 09, 2024 at 10:00:11AM -0000 schrieb Jon Ribbens via Python-li= st: > 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 ? Karsten =2D- GPG 40BE 5B0E C98E 1713 AFA6 5BC0 3BEA AC80 7D4F C89B