Path: ...!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: Tue, 10 Sep 2024 17:56:24 +0200
Lines: 16
Sender: <karsten.hilbert@gmx.net>
Message-ID: <mailman.4.1725983782.31645.python-list@python.org>
References: <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>
 <vbnnuu$2i1cc$1@dont-email.me>
 <slrnvdup6j.4dt.jon+usenet@raven.unequivocal.eu>
 <vbnoio$2i1cc$6@dont-email.me>
 <slrnve01c6.4dt.jon+usenet@raven.unequivocal.eu>
 <ZuBsKKKHUH6OreGT@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 G4fY6e+WBuaRlDbc7PpdVgTqi22mnVnS6fjfqF0omRiQ==
Cancel-Lock: sha1:L0//cbEhz/c/bUEwSuPZRCyD4N0= sha256:BMGKLOGp7I5G+Wh1jOBHRSZfnh+FTFyZ72JhIpDXpHI=
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=OVti2nHx; dkim-adsp=pass; dkim-atps=neutral
X-Spam-Status: OK 0.025
X-Spam-Evidence: '*H*': 0.95; '*S*': 0.00; 'received:212.227': 0.07;
 'gpg': 0.09; 'karsten': 0.09; 'moved': 0.09; 'schrieb': 0.09;
 'subject:Python': 0.12; '"in': 0.16; '1713': 0.16; '2024': 0.16;
 'ok.': 0.16; 'received:212.227.15': 0.16; 'tue,': 0.19; 'to:addr
 :python-list': 0.20; 'all,': 0.20; 'saying': 0.25; 'again,': 0.26;
 'brought': 0.26; "isn't": 0.27; 'asked': 0.29; 'sep': 0.32;
 'header:In-Reply-To:1': 0.34; 'automatic': 0.35; "we've": 0.39;
 'happen': 0.40; 'something': 0.40; '10,': 0.61; 'received:212':
 0.62; 'received:91': 0.62; 'away': 0.67; 'subject:List': 0.71;
 'happens': 0.84; '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=1725983780; x=1726588580; i=karsten.hilbert@gmx.net;
 bh=4hhG5b85x58JOcAe5dLmSF7P2vup6xXAiKMvjnUKv9U=;
 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=OVti2nHxC/rMO/wyNmp2dmuqTAIv9bXvtECBU6NUp3xuyvofq1qqLUEYM42NZl1E
 R574fK2iA3LmmmTf63/AW0O1ZTuaHqKO+LpWpdj0zPv7Nn6CZhpqMKtso2hNigZKW
 hQep4wof55oVtUKEktqTE2+JB2hA6j2KMMDdT4zV/viYgWEnSIHQV9ODnCtvrhfsW
 NxXpTdZ8o1wASCuKvu09UMDFDVWwXhwOYVtevz22s6ZXHhjSl3uja145qd9lCxfY5
 To7XDYMgWMXOssdgOmZ5QkLa2wSRe9PeDS0UGCQoNpbyYFrJl/shC1e8dC8iwbFKo
 jLi1k2WxgaUX2FFIuA==
X-UI-Sender-Class: 724b4f7f-cbec-4199-ad4e-598c01a50d3a
Content-Disposition: inline
In-Reply-To: <slrnve01c6.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:k43+PjJTKZYY7SP2HvA3Oz6/3kYD/yR68efzC/bKbp/H+KRU/1f
 i/1ZYzplY90pyLhSx+nTMeO0VAENTdWtrb6cGxaQwtya85eaxSLLfaPAzKo7uDUunEn4lGN
 UXcQxGidn5JjAXSpeQwcOJtD/of9Heocf521LzggtpthVpDJvD4GQ6mOF3iIrsidogCWbMi
 /ZUF1EpGfJT6z4dDNfhhQ==
X-Spam-Flag: NO
UI-OutboundReport: notjunk:1;M01:P0:1Jesd+lGwKA=;N/kpVmr/9Vc88uEO5WYN36ENWpT
 Ts5nI+DiDGoo5xDSjJoOzhNGA6s2DA+tdMRjepkqGa0sUqRbQYr9AkNUKLViWlgu21rnTr2nO
 DLQKLJY1n/fdZcQAP4WFZC2K8jpm5VbX/lEKTRvVUzjTIuQsO9sDZ6yP3PtVwgHnEK0iwIfpd
 27r2AXXjYhsPHDDbKjfKsI51R2+BN+DvCWj+jHIy5wD/N3+iYFlTdTjd+mEC6g2I6d0JZmRj4
 eceVIWEp8ZMcXDtByZC1rhANnJcWe9idba7qztG89OAoW4JB944UM2HsrDZYCKEq1cyEunsgZ
 oh+5c+LPQxlsv3p/M0ZEIXgqsgmO1L6nkgu9kCnw7CwStfAn2t6uL1XUeB0/s5DJDXEbT3vyh
 Tw45F4NAybnKSmXluHUq26FK3Jhk+NBYXVPP1GWsMQ1Bn5HXBE5XpXeFj57AsEMmH2PfJCKU1
 85OsVjxGuQlbSnYzJiOv11zsy2VRObJeXbglYibpqYrlRqBokxEFbHO5kJzVPAtIofRhKR3ZK
 saIXk5+41ZytyQkgC0y0ou+RlCq63XIV+HC4OkajXvXSUOhLq21JYJyY83riMCOdfahAfSYWE
 mZNbpfYlugleuKtw25iPpgHYQ5EDi0S3Ojn2KDY/cU7+yRMD2Px4pY0/YMp1CumVw6V1wo3/F
 cftTQ7YdAdX+/9tYxtmmwcKxeNwFvXeeZzyCmXuZPM2UdumJFOdk5nkBn1T9vXd5UeUzXK8Er
 RV9xkxxWafgD+3Rm2m+wux6LKhVR0KyZmxsIBSRBqRl65+Ms0EL7dWHcipUomLrJSKm1ozLmQ
 5si8TDt4JOh5oR5SaN2sdt9Q==
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: <ZuBsKKKHUH6OreGT@hermes.hilbert.loc>
X-Mailman-Original-References: <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>
 <vbnnuu$2i1cc$1@dont-email.me>
 <slrnvdup6j.4dt.jon+usenet@raven.unequivocal.eu>
 <vbnoio$2i1cc$6@dont-email.me>
 <slrnve01c6.4dt.jon+usenet@raven.unequivocal.eu>
Bytes: 6171

Am Tue, Sep 10, 2024 at 08:38:30AM -0000 schrieb Jon Ribbens via Python-li=
st:

> Ok. So we've moved away from "In any DBMS worth its salt, rollback is
> something that happens automatically"

Nope. The original post asked something entirely different.

> and now you're saying it isn't automatic after all,

No again, such shenanigans only start to happen when pooling
is brought into the equation.

Karsten
=2D-
GPG  40BE 5B0E C98E 1713 AFA6  5BC0 3BEA AC80 7D4F C89B