Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mbUIx-0006DB-3L for psycopg@arkaria.postgresql.org; Fri, 15 Oct 2021 20:59:51 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mbUIw-0000OE-2D for psycopg@arkaria.postgresql.org; Fri, 15 Oct 2021 20:59:50 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mbUIv-0000O4-Eq for psycopg@lists.postgresql.org; Fri, 15 Oct 2021 20:59:49 +0000 Received: from black.elm.relay.mailchannels.net ([23.83.212.19]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1mbUIr-0002Tt-Mu for psycopg@postgresql.org; Fri, 15 Oct 2021 20:59:48 +0000 X-Sender-Id: cp7oy65bvo|x-authuser|paolo@paolodestefani.it Received: from relay.mailchannels.net (localhost [127.0.0.1]) by relay.mailchannels.net (Postfix) with ESMTP id B9B5021787; Fri, 15 Oct 2021 20:59:41 +0000 (UTC) Received: from lu-shared04.cpanelplatform.com (unknown [127.0.0.6]) (Authenticated sender: cp7oy65bvo) by relay.mailchannels.net (Postfix) with ESMTPA id B8090217A7; Fri, 15 Oct 2021 20:59:40 +0000 (UTC) X-Sender-Id: cp7oy65bvo|x-authuser|paolo@paolodestefani.it Received: from lu-shared04.cpanelplatform.com ([UNAVAILABLE]. [107.189.4.2]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384) by 100.100.96.88 (trex/6.4.3); Fri, 15 Oct 2021 20:59:41 +0000 X-MC-Relay: Neutral X-MailChannels-SenderId: cp7oy65bvo|x-authuser|paolo@paolodestefani.it X-MailChannels-Auth-Id: cp7oy65bvo X-Cooperative-Abiding: 7d62b8557a279906_1634331581479_2921995631 X-MC-Loop-Signature: 1634331581479:2390464970 X-MC-Ingress-Time: 1634331581478 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=paolodestefani.it; s=default; h=Content-Transfer-Encoding:Content-Type: Message-ID:References:In-Reply-To:Subject:Cc:To:From:Date:MIME-Version:Sender :Reply-To:Content-ID:Content-Description:Resent-Date:Resent-From: Resent-Sender:Resent-To:Resent-Cc:Resent-Message-ID:List-Id:List-Help: List-Unsubscribe:List-Subscribe:List-Post:List-Owner:List-Archive; bh=9GwFK23TcodycPXg0s/xaIiL6Lt05jtEYwdBRH4E+xM=; b=nGz7IBSGOzo9MvHdkFVAyvq2Yc IvJSTzpiHoFwOwZJGd/DZ73c6nBE41Cx6W2XgkOf/57Rk2rkSjhMCtv/LEXJdXbwIWrnbZrFkkndB r8kb5Hn/jzYVplTOh9xlOC7uUPUiUw/Khvl7iAnMMlBqw61U/edCPAl0FOz4/QZzLuHodBWYguCZW kWoD7NMaiG7MyckBAcbL20c8BAcqHigHBr5Em+nauOphcGUJ9U+D8i5BeFa2PELBNiup2CVrpUEK2 U/5Ug8LQVMvXCIYA5/zbk5lLEOXIv7D+fAl7rTxm2CaMhDszYrtTuhZynNvNxcBN8PKI7uNasg1ZP UrjfeEwA==; Received: from [::1] (port=54198 helo=lu-shared04.cpanelplatform.com) by lu-shared04.cpanelplatform.com with esmtpa (Exim 4.94.2) (envelope-from ) id 1mbUIk-0078tL-A8; Fri, 15 Oct 2021 22:59:38 +0200 MIME-Version: 1.0 Date: Fri, 15 Oct 2021 22:59:38 +0200 From: Paolo De Stefani To: Daniele Varrazzo Cc: Psycopg Subject: Re: psycopg3 transactions In-Reply-To: References: <9a99d2d110b121542d1ea0a05066858b@paolodestefani.it> <6683df3e65fe961aa478e61db7ad687d@paolodestefani.it> User-Agent: Roundcube Webmail/1.4.11 Message-ID: <77e106b39df5f9ce6fe30c4e7be2263e@paolodestefani.it> X-Sender: paolo@paolodestefani.it Content-Type: text/plain; charset=US-ASCII; format=flowed Content-Transfer-Encoding: 7bit X-AuthUser: paolo@paolodestefani.it List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk It seems much clearer to me now This makes me think that maybe it's worth trying to use an autocommit connection... Il 15/10/2021 12:56 Daniele Varrazzo ha scritto: > On Wed, 13 Oct 2021 at 19:28, Daniele Varrazzo > wrote: > >> Pretty much everyone comes from psycopg2, so we should definitely >> improve the docs :D > > I have expanded the documentation about transaction behaviour. > Feedback is welcome. > > https://www.psycopg.org/psycopg3/docs/basic/transactions.html > > Paolo, Daniel: I am especially keen to have your feedback as one > newcomer and the other pretty much the authority in transaction > management :) > > Cheers, > > -- Daniele -- Paolo De Stefani