Horton

foreign join error "variable not found in subplan target list"

Alexander Pyhalov <a.pyhalov@postgrespro.ru>

View thread View on postgr.es
From: Alexander Pyhalov <a.pyhalov@postgrespro.ru>
To: pgsql-bugs@lists.postgresql.org
Date: 2022-08-08T15:26:44Z
Lists: pgsql-bugs

Attachments

Hi.

Using the following patch I'm able to get
"ERROR:  variable not found in subplan target list"
on foreign join pushdown for update returning.
It seems that we generate Result node which has 7 vars in targetlist 
over Sort plan node, which has only 6 vars in targetlist.

So far not sure what causes this.

-- 
Best regards,
Alexander Pyhalov,
Postgres Professional

Commits

  1. postgres_fdw: Avoid 'variable not found in subplan target list' error.