Re: BUG #14249: In FDW, variable not found in subplan target list

wayne(dot)warren(at)multiscalehn(dot)com writes:
> I have written a foreign data wrapper that works with version 9.5.2. Now
> with 9.6beta2 I receive "ERROR: variable not found in subplan target list"
> when I refer to a column in the WHERE clause that is not also listed as a
> target column:

> mydb=# select record_id, addr_chg_user_id from si_ept_470
> where addr_chg_instant='5441342125';
> ERROR: variable not found in subplan target list

No such misbehavior is visible in file_fdw or postgres_fdw, so presumably
your FDW is doing something wrong. There's not enough information here
to say what; though a likely guess is that you're building a custom
fdw_scan_tlist and forgetting to include Vars from restriction clauses
in it.

regards, tom lane