Re: TRAP: failed Assert("outerPlan != NULL") in postgres_fdw.c

Michael Paquier <michael@paquier.xyz>

From: Michael Paquier <michael@paquier.xyz>

To: Etsuro Fujita <etsuro.fujita@gmail.com>

Cc: Masahiko Sawada <sawada.mshk@gmail.com>, PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>, kristianlejao@gmail.com

Date: 2025-10-06T03:37:21Z

Lists: pgsql-bugs

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

Fix EvalPlanQual handling of foreign/custom joins in ExecScanFetch.
- 24e74b9621e4 14.20 landed
- 12b0c0e51b2f 13.23 landed
- 4a08603a2322 15.15 landed
- 5a9af48689dc 16.11 landed
- 2bb84ea7ef89 17.7 landed
- b14144325984 18.1 landed
- 12609fbacb00 19 (unreleased) landed

Attachments

v6-0001-postgres_fdw-Fix-assertion-failure-when-EvalPlanQ.patch (text/x-diff) patch v6-0001

On Mon, Oct 06, 2025 at 02:15:25AM +0900, Etsuro Fujita wrote:
> The isolation test fails.  I think you failed to update the expected
> file.  Also, you left the useless alias for table a alone...

Yep, the EXPLAIN plan was missing.  Another thing that you have missed
is to update postgres_fdw's .gitignore so as it discards /output_iso/.

The updated patch attached, labelled v6, addresses all that.
--
Michael