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 1o8WAw-0001eH-5W for pgsql-bugs@arkaria.postgresql.org; Tue, 05 Jul 2022 00:12:22 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1o8WAs-0004re-WE for pgsql-bugs@arkaria.postgresql.org; Tue, 05 Jul 2022 00:12:19 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1o8WAs-0004ol-2Y for pgsql-bugs@lists.postgresql.org; Tue, 05 Jul 2022 00:12:18 +0000 Received: from wout2-smtp.messagingengine.com ([64.147.123.25]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1o8WAn-0000Qm-7p for pgsql-bugs@lists.postgresql.org; Tue, 05 Jul 2022 00:12:16 +0000 Received: from compute3.internal (compute3.nyi.internal [10.202.2.43]) by mailout.west.internal (Postfix) with ESMTP id 5A59F3200786; Mon, 4 Jul 2022 20:12:10 -0400 (EDT) Received: from mailfrontend2 ([10.202.2.163]) by compute3.internal (MEProxy); Mon, 04 Jul 2022 20:12:10 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= cc:content-type:date:date:from:from:in-reply-to:in-reply-to :message-id:mime-version:references:reply-to:sender:subject :subject:to:to; s=fm2; t=1656979929; x=1657066329; bh=KkUaWXte2G RUsgsGdY9gYyCUNj/gekJOAJ+xsX/llt4=; b=T7cvFGPpjGPihz0stc9c/vQk9l 2hqKHLNa0+PwGdY0v05Gl4JYfXCWvD3XFjbhy8q8SP09l16azU1jqp9OkyOv1lWX SKhVJZLwU3ImdCJy3zd9qWIbTYunrxrrAltslxwvY78dDW9+16c6HRQZdHAHvY5l btrm+RTqEAGStQaX33vDgUDKxeM65seznBGbt+8yPKV5o4Vum/0gfBFvZIAKFfct inZFH4lN7jp/agiWCNVTOB03OJ+poa+uQ8Kea2n9mt50ZL0t1zA7fsDeBSzXz1gw sZtQbBUeYjI7qF/lD9GwNm7b5Fo9rrMerkgyJHlEnwMgWeWCGmusQrWiBOIw== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-type:date:date:feedback-id :feedback-id:from:from:in-reply-to:in-reply-to:message-id :mime-version:references:reply-to:sender:subject:subject:to:to :x-me-proxy:x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s= fm2; t=1656979929; x=1657066329; bh=KkUaWXte2GRUsgsGdY9gYyCUNj/g ekJOAJ+xsX/llt4=; b=jcJPkLiPIuNxwpjRksQwAw3Ca/yfssfiFro3dmyFyg4G FXJaIGQRIZm1TrE1gBegrEd8YusPDxZeRXIjMiwZC34slmKIJP9AukghvrKvV5yZ WFL9U1d74MRSpPkjxZd+Xs7eKs+6EkD/RS8iP/dV4dnerqb9z7s6USV9e1VmTJrs n5ftPd5JUP+/JDWyquaOFvt7bXaFpJn3qSOAWP1VKhgIC5y3zjjLo/i79hj7yJSZ A3egEy/WrzyVK2ctqYAzvWIG1TTQ50dxlHcmA7GPo9EWnN3mAhHip30cUrr85er3 9s+8u98JgbiDuP9vpzp5mGfZ9rtB7v7pJy8AkIIJQQ== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvfedrudeitddgvdelucetufdoteggodetrfdotf fvucfrrhhofhhilhgvmecuhfgrshhtofgrihhlpdfqfgfvpdfurfetoffkrfgpnffqhgen uceurghilhhouhhtmecufedttdenucesvcftvggtihhpihgvnhhtshculddquddttddmne gfrhhlucfvnfffucdljedtmdenucfjughrpeffhffvuffkfhggtggujgesghdtreertddt vdenucfhrhhomhepofhitghhrggvlhcurfgrqhhuihgvrhcuoehmihgthhgrvghlsehprg hquhhivghrrdighiiiqeenucggtffrrghtthgvrhhnpedvgeduuefhtdeuleettdevjeeh heeiveeuieegleetgeeljeelieeuieehgeevhfenucevlhhushhtvghrufhiiigvpedtne curfgrrhgrmhepmhgrihhlfhhrohhmpehmihgthhgrvghlsehprghquhhivghrrdighiii X-ME-Proxy: Feedback-ID: i0fe9450f:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Mon, 4 Jul 2022 20:12:07 -0400 (EDT) Date: Tue, 5 Jul 2022 09:12:03 +0900 From: Michael Paquier To: Christoph Berg , Tom Lane , Kyotaro Horiguchi , robertmhaas@gmail.com, pgsql-bugs@lists.postgresql.org Subject: Re: BUG #17504: psql --single-transaction -vON_ERROR_STOP=1 still commits after client-side error Message-ID: References: <2649417.1654875709@sss.pgh.pa.us> <2656555.1654877531@sss.pgh.pa.us> <20220613.160701.975499861789120736.horikyota.ntt@gmail.com> <3791929.1655131936@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="FpzF8D+LHsn2rkPZ" Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --FpzF8D+LHsn2rkPZ Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Mon, Jul 04, 2022 at 04:38:26PM +0200, Christoph Berg wrote: > Is there anything left to do to fix up the --single_transaction + > ON_ERROR_STOP case here? From reading the code, it now does what it > should do. What is left to do for backpatching it? As per upthread, Tom and Robert do not seem to agree on this point. And it is true that this creates a behavior change. At this stage, it could be a good idea to gather more votes. -- Michael --FpzF8D+LHsn2rkPZ Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmLDgdMACgkQnvQgOdby QH1U+Q//WcCrmzjNz1d6hC8lbFmOAJ8cd+d331rZGT4kxmSC7SFUi+U/RNDOdOh/ ulCGb7yhv4nUfastO1XxilP01AQQuNYxzPkj8xoqZolUVBkIepaQ6PozqKpmHqOX N5V+CGUlQuiMCWKUTuGmabOks0S2h7FcwnI9mr06mqpr+//kLsA3laUvCi5BbQVE 4KD6hwirdJR7fQ8ERKJCEpR0MMmw4dVmMwdYKSCiPgubxp8cJD1nUaavroLYNzZi Z7jIzXiuh0RQH6P+TMJiMfhQPe/4ltzk/h1Ws6mKF7SPmRctlX1y+r89HPoTBgBv /dTJlajyoNi6UN0DuQXh3p3Yn1PcHsWhezPPx/fHDWlzGVIE26DwlOOkX/VnqGvy ro7iD7nv59wDrC7LeEUw4MU7rgqOSeHBGdUIsxp/TRuEsM+y4Wdiiu0zdE4Ssj0n rF7LqkG1PG7+8Z42puvkv9RtYnzKDBKc++SWf/oSjgwBNPTrImr3xTVivtEM8NiD spKzEke/1KYUVVdFEnaQqX7przp5R9f3250kzVAzMnK/H4SHUjeIhJ00zaU3oZ+R jRoBOk9CXhKJI/WjxRME1ln4jJ3G1pB/j6+qL2fS5Y2WYSJhWW8Aw2t72mAcvkJh fHLBvIqpJumF7roD8CsR/BgzSNjsow3ZZ/cSlOQ2+RXawesaqVY= =1s2C -----END PGP SIGNATURE----- --FpzF8D+LHsn2rkPZ--