Re: syntactically correct query gives ERROR: failed to assign all NestLoopParams to plan nodes

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Stephan Springl <springl-psql(at)bfw-online(dot)de>
Cc: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: syntactically correct query gives ERROR: failed to assign all NestLoopParams to plan nodes
Date: 2021-01-17 02:18:42
Message-ID: 171312.1610849922@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Stephan Springl <springl-psql(at)bfw-online(dot)de> writes:
> running
> psql -f NestLoopParams.sql
> gives
> psql:NestLoopParams.sql:16: ERROR: failed to assign all NestLoopParams to plan nodes
> psql:NestLoopParams.sql:24: ERROR: failed to assign all NestLoopParams to plan nodes

Thanks for the report! This turns out to be not entirely trivial
to fix. I've started a discussion about it at [1]. One way or
another we should have a fix in place for February's releases.

regards, tom lane

[1] https://www.postgresql.org/message-id/171041.1610849523%40sss.pgh.pa.us

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Noah Misch 2021-01-17 07:24:54 Re: CREATE INDEX CONCURRENTLY does not index prepared xact's data
Previous Message Tom Lane 2021-01-16 23:28:23 Re: BUG #16824: Planner chooses poor path on query with Merge Join and pagination