Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qn8hJ-009wTT-Ll for pgsql-bugs@arkaria.postgresql.org; Mon, 02 Oct 2023 02:30:14 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1qn8hH-00GCTC-1v for pgsql-bugs@arkaria.postgresql.org; Mon, 02 Oct 2023 02:30:11 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qn8hF-00GCSV-Jf for pgsql-bugs@lists.postgresql.org; Mon, 02 Oct 2023 02:30:10 +0000 Received: from out1-smtp.messagingengine.com ([66.111.4.25]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qn8h8-007hf1-WB for pgsql-bugs@lists.postgresql.org; Mon, 02 Oct 2023 02:30:08 +0000 Received: from compute7.internal (compute7.nyi.internal [10.202.2.48]) by mailout.nyi.internal (Postfix) with ESMTP id 1A1625C0324; Sun, 1 Oct 2023 22:27:52 -0400 (EDT) Received: from mailfrontend2 ([10.202.2.163]) by compute7.internal (MEProxy); Sun, 01 Oct 2023 22:27:52 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= cc:cc:content-type: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=1696213672; x=1696300072; bh=hQ 73/S8baMGOtoNIbO+xwJ2uIONTslcWhDoggnQLHAQ=; b=Rn6gjdPc/R9fn8Cyn9 ScJAPTFD458cez16jjNiRM6dzMHe3xEXBHTUP+teezLACAi2GDmafEeN4MsQxAZw xXtrnNEQJD8Lf3LX8nlDhe2RRyOt7SxozwBvtFS8uXqiYhPgsFLgRAzpudFP1mKC F6JIiMuaY7xidnvLujAHcqhyIP0xnh+wMmE8IMUF/rRQ6QIoJ5EOg613vIrPxHru 4JYw1IgQBcFq6khkjjJw7ag8DEL5P073hH8J7Z1ZWibVE/9mR1CeoiPr2qSB2h5L n5/pq/Ic38MrJ2nSwuGtg3aKXAKIVRzLfIjLlfvZgS+2e1ITGvZwmz8NESrBGh7o XPCw== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-type: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=1696213672; x=1696300072; bh=hQ73/S8baMGOt oNIbO+xwJ2uIONTslcWhDoggnQLHAQ=; b=f8OCbyl+ljXx2qtcmkCtHc5iLYWYl 1ItykXQtUX0B372IEru0UP19dnC8RYpF4qVz6b2rocK6m5+fzFoBhZvjdiK8yBi3 l7x/BmzNsb1IIjMbs6ZRyCngYjvlikFOUEkyjvgQ0uKwenIz1nMUTpnDFnNHuSnS P7gGL+OTnyEhbBNsw3zxU40LA+EaDCLY9Y3cqFsSY6yM7wykbcmppZtL4UHtkD0/ iYa88Gy4dPpjrRRTP7p+xX5cbFecuptucQZaY9vllQVfOeVig1F19v4BENqp+m/Z fF5eKvIPJ4jmS+BBHvrVuzMbAuhPWZH2kIeaDZRoONxIuDL+JrOjKYo8A== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvkedrvdeigddthecutefuodetggdotefrodftvf curfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfghnecu uegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmdenfg hrlhcuvffnffculdejtddmnecujfgurhepfffhvfevuffkfhggtggujgesghdtreertddt vdenucfhrhhomhepofhitghhrggvlhcurfgrqhhuihgvrhcuoehmihgthhgrvghlsehprg hquhhivghrrdighiiiqeenucggtffrrghtthgvrhhnpeetleeifedufffhhfdtteelgeeg geffhfekueevteeigfduudevudetgfegiedvjeenucevlhhushhtvghrufhiiigvpedtne curfgrrhgrmhepmhgrihhlfhhrohhmpehmihgthhgrvghlsehprghquhhivghrrdighiii X-ME-Proxy: Feedback-ID: i0fe9450f:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Sun, 1 Oct 2023 22:27:48 -0400 (EDT) Date: Mon, 2 Oct 2023 11:27:45 +0900 From: Michael Paquier To: Tom Lane Cc: Japin Li , amutu@amutu.com, pgsql-bugs@lists.postgresql.org Subject: Re: BUG #18134: ROW_COUNT do not set to 0 when psql's \gset command get no rows returned Message-ID: References: <18134-87126d90cb4dd049@postgresql.org> <1615012.1696121047@sss.pgh.pa.us> <1617077.1696121892@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="aNTNLgtVcWQjpup2" Content-Disposition: inline In-Reply-To: <1617077.1696121892@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --aNTNLgtVcWQjpup2 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline On Sat, Sep 30, 2023 at 08:58:12PM -0400, Tom Lane wrote: > I'm content to wait a day and see if anybody wants to make an > argument for back-patching. Okay. Seeing nothing, I've looked more at that this morning and applied the change to HEAD, for now. -- Michael --aNTNLgtVcWQjpup2 Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmUaKqEACgkQnvQgOdby QH0V8g/+MWd/Hm6ytiuOFFPkCQpupzLW16r75H46MuViky3+oR/6Yg6HNaC5IGPD jKPfjONV/QFTnj1a2/aq2mxQCoVRo+rO4AWFoGCREvh5+iIhmVZfXAhg7qFSA4ka VbJu5D1OXdTn9tYpm/YXGRev4NG72bSsICojKX3w5GY7G0f0Y7a924H+k6ePSucS W8WYaHzn+mK9ccD3iTz8yU5cgVTh4R3PupXnmkwaaorj44ZuNZa0vnjI/BaEX1Rf v/7GUz2cWqxCHZWA10ImIOM8qBOTijD/kDVrS144js1KFVBxcE7t2KYzdZIStayW P7f4O5XsPNlr2Oy3a/CX/OXohxUqfatzAH4O0xYZn/ivh9q0Lrr9Z30uMfQhCc6W YxsVIZ2mCFzCmBmAWwovrAw8YyJUooNf6j96XROee8vITjLRG6+ECbAND0hOQITs xTKH0bsoWET3jcT50FpsVMQNvA0WOg0BizxbC+NVvzMdIQ+Qfz9S5Cjzj5YQcRRU JzszBGGvDJC7i7P+BEw9EC+ai6vqzisbSTCMfZNCryjG26Z5rvafsGh4ZPXm3Iy9 W62VJgESzGDvxT5fWxZggw940k6vGYXEvTQf+oCfjHfSv4t8R131bXYF+w41KcU3 Q/YE92Uck3QA8R+zl84k/S6tBBrMgIjbpHXmjHFhe0tRia6GFPQ= =nm+c -----END PGP SIGNATURE----- --aNTNLgtVcWQjpup2--