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 1ubeqb-003cL6-OR for pgsql-bugs@arkaria.postgresql.org; Tue, 15 Jul 2025 12:33:26 +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 1ubeqY-001e7b-Cw for pgsql-bugs@arkaria.postgresql.org; Tue, 15 Jul 2025 12:33:23 +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 1ubeqX-001e7T-E9 for pgsql-bugs@lists.postgresql.org; Tue, 15 Jul 2025 12:33:22 +0000 Received: from fhigh-a2-smtp.messagingengine.com ([103.168.172.153]) by makus.postgresql.org with smtp (Exim 4.96) (envelope-from ) id 1ubeqW-007P7g-0B for pgsql-bugs@lists.postgresql.org; Tue, 15 Jul 2025 12:33:21 +0000 Received: from phl-compute-12.internal (phl-compute-12.phl.internal [10.202.2.52]) by mailfhigh.phl.internal (Postfix) with ESMTP id 87A8D140021B; Tue, 15 Jul 2025 08:33:18 -0400 (EDT) Received: from phl-mailfrontend-02 ([10.202.2.163]) by phl-compute-12.internal (MEProxy); Tue, 15 Jul 2025 08:33:18 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=kurilemu.de; h= cc:cc:content-transfer-encoding:content-type:content-type:date :date:from:from:in-reply-to:in-reply-to:message-id:mime-version :reply-to:subject:subject:to:to; s=fm1; t=1752582798; x= 1752669198; bh=+uAVYQ7SBiMtq71c5VRwQCqV3DiPROpCQWHAPThyw9A=; b=k NoZKzB/lRFNI8HWBRX3+eCQVAO0Pz1NsidbdHE3Sb+bQta6BXQGAX7Qc/sc/ZAjD sxIF805Ba92Et6plDdQI7ID5+1IRg3ZbksWS9rAHtv3a8AikUqaA0QHLiTakg84d 5wzphReq0wFFzCAUsr/g1o+QGyEjEJ8BQxLJpjlVtFhMXzXloCh3F8G4IY8UjK+0 Fp7QkxauisBoTJNHfxtFAf8nu13iLAkBeg0QWRSNbGPzFklHkY2IBSc9mz4hnI6m aWP//taRo7SqtNzd2/XbHzPZ5Ta1hSIu/Ahn2aTzY365eaZ3NmzA3sxqL2/WULLu hQHGNwkRzfRN5zbrGU1yA== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-transfer-encoding :content-type:content-type:date:date:feedback-id:feedback-id :from:from:in-reply-to:in-reply-to:message-id:mime-version :reply-to:subject:subject:to:to:x-me-proxy:x-me-sender :x-me-sender:x-sasl-enc; s=fm2; t=1752582798; x=1752669198; bh=+ uAVYQ7SBiMtq71c5VRwQCqV3DiPROpCQWHAPThyw9A=; b=hixYPhNhBComFRpUI 6L7vE95ydZ/5A1Gk6+A/j4QBAnPzSx6lN47RjSb956biw52rP+Xq9mvweJXrPYTW MSj7j4NcKmuntCtrzKq68M3VoAT+5yAE50TKUespI34QDVPFeMlf4iEnuvCiQ0U3 th0R1mMLmPiLfxCBZkQmCCtFEnbIb1CoIVYeGJ3pinA4vLa+dxX/HmKy154EdJF1 QST2ijzo9ig0PSbJBZskBcNakwOvglUxBEXapV3bCmCZf7d/+QV6R4gSYTaacvSk Zq1Qn1g7EB9DRTbmovf1mGpbOEiPySibFdvZhm/HAGvk8phnMwf0SU+F1FZhtqPM Ax4og== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeeffedrtdefgdehgeekgecutefuodetggdotefrod ftvfcurfhrohhfihhlvgemucfhrghsthforghilhdpuffrtefokffrpgfnqfghnecuuegr ihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmdenucfjug hrpeffhffvvefukfggtggugfgjsehmkeerredttdejnecuhfhrohhmpemllhhvrghrohcu jfgvrhhrvghrrgcuoegrlhhvhhgvrhhrvgeskhhurhhilhgvmhhurdguvgeqnecuggftrf grthhtvghrnhepgedutedujeehudevveegheejgeelveevvedvuedtjedtkeeuhfehheeg vedtjeetnecuffhomhgrihhnpegvnhhtvghrphhrihhsvggusgdrtghomhenucevlhhush htvghrufhiiigvpedtnecurfgrrhgrmhepmhgrihhlfhhrohhmpegrlhhvhhgvrhhrvges khhurhhilhgvmhhurdguvgdpnhgspghrtghpthhtohepgedpmhhouggvpehsmhhtphhouh htpdhrtghpthhtohepvgigtghluhhsihhonhesghhmrghilhdrtghomhdprhgtphhtthho pehpghhsqhhlqdgsuhhgsheslhhishhtshdrphhoshhtghhrvghsqhhlrdhorhhgpdhrtg hpthhtohepmhhitghhrggvlhesphgrqhhuihgvrhdrgiihiidprhgtphhtthhopehtghhl sehsshhsrdhpghhhrdhprgdruhhs X-ME-Proxy: Feedback-ID: ie3de48e3:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Tue, 15 Jul 2025 08:33:17 -0400 (EDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=kurilemu.de; s=schmee; t=1752582794; bh=ktGA99J6gOCYAHAkn9X/R4888QV2ZAjv5ITYZL7IHJI=; h=Date:From:To:Cc:Subject:In-Reply-To:From; b=5UE3CiyXCAgyfKAzyKP9tg7Ba3e6zC/Ten7tpvp+gE6YB4Jgh5rKv6hglywzSq7vo ftKtOVQQXIUvXJmQrEJaY76MAFPFAC4iK+fEjgQ3FKHNEgFI1j8+MIoMQUXcEknMw+ OtMG2FuICz4SP6vN50aHnLS9lYWQbDcOSofwG6tGIdVGRcuWOLfOkHA0LsnHSrFqaZ 4L2qm+b+SX+/ehtw4IPVkkgrbZojEnyLvRiMfJxEbSn05ajTc76Q7TxAOpm5jOUUyA 9uXxzHyNpP6QZgWKipYf40AD85RD6aaLi9m/360i0LmS7wIIa6VGfyL3ThMhFGKyW3 vcIFHhfyR1Ebw== Received: by schmee.kurilemu.internal (Postfix, from userid 1000) id 1EFB68D; Tue, 15 Jul 2025 14:33:14 +0200 (CEST) Date: Tue, 15 Jul 2025 14:33:14 +0200 From: =?utf-8?Q?=C3=81lvaro?= Herrera To: Tom Lane Cc: Michael Paquier , exclusion@gmail.com, pgsql-bugs@lists.postgresql.org Subject: Re: BUG #18984: Empty prepared statement from psql \parse triggers assert in PortalRunMulti Message-ID: <202507151233.n5jw4x3jtc2g@alvherre.pgsql> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="whnk3kdrd6zf7kgd" Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: <834745.1752555566@sss.pgh.pa.us> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --whnk3kdrd6zf7kgd Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit On 2025-Jul-15, Tom Lane wrote: > Michael Paquier writes: > > ... I am wondering if we should not just nuke the assertion at the end > > of PortalRunMulti() instead, relying on the same check done at the > > beginning of ProcessUtility(). > > Yeah, I was starting to think about that solution too. Removing > code seems nicer than adding more. Yeah, this makes sense to me too. I'd rewrite the comment while at it, because what's being described as "printing 0 0" no longer occurs in this form in this place anymore. Maybe we could discuss adding some commentary to EndCommand where this now happens, but I don't think we really need it. -- Álvaro Herrera 48°01'N 7°57'E — https://www.EnterpriseDB.com/ --whnk3kdrd6zf7kgd Content-Type: text/x-diff; charset=utf-8 Content-Disposition: attachment; filename="0001-Remove-assertion-in-PortalRunMulti-simplify-comment.patch"