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 1v28b4-000eez-H3 for pgsql-bugs@arkaria.postgresql.org; Fri, 26 Sep 2025 13:34:50 +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 1v28b1-001azH-Db for pgsql-bugs@arkaria.postgresql.org; Fri, 26 Sep 2025 13:34:48 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1v28b1-001az9-2z for pgsql-bugs@lists.postgresql.org; Fri, 26 Sep 2025 13:34:47 +0000 Received: from fout-b1-smtp.messagingengine.com ([202.12.124.144]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1v28az-000EAx-07 for pgsql-bugs@lists.postgresql.org; Fri, 26 Sep 2025 13:34:47 +0000 Received: from phl-compute-03.internal (phl-compute-03.internal [10.202.2.43]) by mailfout.stl.internal (Postfix) with ESMTP id A89E91D0004C; Fri, 26 Sep 2025 09:34:42 -0400 (EDT) Received: from phl-mailfrontend-01 ([10.202.2.162]) by phl-compute-03.internal (MEProxy); Fri, 26 Sep 2025 09:34:42 -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=fm3; t=1758893682; x= 1758980082; bh=Ig9VOiUozZ12MTZWWmPW6alOp53HFqAQWWi5/eCCG28=; b=k SbUsOr4fSXxEsvZMa9EaZlBhcnmuTTJHeKeyZto0lpV0XQfblWUU9OMCN3lSXl4n TiyI6W7yPNqUieXK8aAURaHhD3utNxMOZ9ddM4bvp3bzDfeIJr8fCH2sT9dREo4V DPnQ2fM94BmXi1ziCnXluB7GIemWYWPK3i4WeZ6yBM6WCY568g/261SCNq/jxhua OV6b7Fdf8s7ecoGQvnm9ZO3WpvbfXSwaT67CUIa6vvUdJWzb4emQiPK2sdOPdiC0 8wfTtHy2vs5VnHYot42SXta2DJoXcJA3h5YMoBYK3ttAZyEJXCa8m00FrfScf54e 8sCq/SR1AG4qnezsmSLcA== 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=1758893682; x=1758980082; bh=I g9VOiUozZ12MTZWWmPW6alOp53HFqAQWWi5/eCCG28=; b=WFmYymWFQ2ctj4XrT lJtGpUNuzvBRKAHbnpPm3za5jFeOZjpoiYq4cLgppBO1sZ9k0svd2WicjaLsifle /ZAoC8MthCU1wIqu24ZHFonDwCs0d8O+7igEi3HxmKXmk5bbQSSop/UO6rCJ5XBU t/bexgunnL85v0U7YULkZT+8YGGSpUHrXkbFg7HsEitvr4A1yJ0TsMncPSbfz6dQ NAPwFjkgvdNHC+TWUYNKSJrnoVfnhV7if/Ajr/qK2beCMKD7slUcqVctojzweeHs x65nw0BWaO5UWcrXX2fIWG9+jyiw946kfhgPd7Q0XZ9g1kdqK+/64DXAkVNE9jXw /ti5Q== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeeffedrtdeggdeileehtdcutefuodetggdotefrod ftvfcurfhrohhfihhlvgemucfhrghsthforghilhdpuffrtefokffrpgfnqfghnecuuegr ihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmdenucfjug hrpeffhffvvefukfggtggugfgjsehtkeertddttdejnecuhfhrohhmpemllhhvrghrohcu jfgvrhhrvghrrgcuoegrlhhvhhgvrhhrvgeskhhurhhilhgvmhhurdguvgeqnecuggftrf grthhtvghrnhepteeuvdehffekvefgueehveetveekgfegtddtueefueehuddutdfhfeff hfejfeffnecuffhomhgrihhnpegvnhhtvghrphhrihhsvggusgdrtghomhenucevlhhush htvghrufhiiigvpedtnecurfgrrhgrmhepmhgrihhlfhhrohhmpegrlhhvhhgvrhhrvges khhurhhilhgvmhhurdguvgdpnhgspghrtghpthhtohephedpmhhouggvpehsmhhtphhouh htpdhrtghpthhtohepvghtshhurhhordhfuhhjihhtrgesghhmrghilhdrtghomhdprhgt phhtthhopehkrhhishhtihgrnhhlvghjrghosehgmhgrihhlrdgtohhmpdhrtghpthhtoh epshgrfigruggrrdhmshhhkhesghhmrghilhdrtghomhdprhgtphhtthhopehpghhsqhhl qdgsuhhgsheslhhishhtshdrphhoshhtghhrvghsqhhlrdhorhhgpdhrtghpthhtohepmh hitghhrggvlhesphgrqhhuihgvrhdrgiihii X-ME-Proxy: Feedback-ID: ie3de48e3:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Fri, 26 Sep 2025 09:34:41 -0400 (EDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=kurilemu.de; s=schmee; t=1758893678; bh=wpz1uvo8SFwxIkkiaBQ9szSYzhugPJaVl5sLuPhEzaA=; h=Date:From:To:Cc:Subject:In-Reply-To:From; b=NPGiJj+uwuGoqpHXnCGFdi2gSXlr22ZRjUSKpoBif4XqtOPoGZ2VYpUrmeIfu9//E 5+2LWolz5Qegg7yNg/+jWN/aJGEyuuGsdahpLLQ5GqPau0H2AzrBN4jpga2REEhrNG PRpkR1Qq1tLD9v4DrAQOdnuvwo1BCnN1SdA1jbRlzKY0fhNdT8EjGvFM3r4bylSr+P jupDROwdw93OaXcQ3O4QuOCcpMPTzN9DJFVUV5fKLDPULzSd7ClBv7/STKSZwkHZ9B Yx+XoAG8VfUDkvM69BGvaF42CcRULGUsaPpeFvZDvGLHGXENR7x+0r8omwOGlXEAPF y8K1XklZYrYrw== Received: by schmee.kurilemu.internal (Postfix, from userid 1000) id D0F9F78; Fri, 26 Sep 2025 15:34:38 +0200 (CEST) Date: Fri, 26 Sep 2025 15:34:38 +0200 From: =?utf-8?Q?=C3=81lvaro?= Herrera To: Etsuro Fujita Cc: Masahiko Sawada , Michael Paquier , PostgreSQL mailing lists , kristianlejao@gmail.com Subject: Re: TRAP: failed Assert("outerPlan != NULL") in postgres_fdw.c Message-ID: <202509261330.5acuwmf57rvu@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 2025-Sep-24, Etsuro Fujita wrote: > I took a quick glance at the patch. My initial comment is: it only > includes the test case discussed here, but I think it's a good idea to > add more cases in it (that exercise code paths in > postgresRecheckForeignScan), as I mentioned upthread. What do you > think about that? If no objections, I'd like to update it to include > such cases. I would like to suggest a different approach: because this patch is known to fix a server crash in a known case, it would be better to get the fix (and its corresponding test) pushed as is without further delay. Additional tests are an excellent idea, but I think we shouldn't make this patch wait for them. If further fixes are deemed necessary for those other (thus far hypothetical) tests, we can still make them afterwards. -- Álvaro Herrera Breisgau, Deutschland — https://www.EnterpriseDB.com/