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

 

To be concrete, I mean something like this:

--- a/contrib/postgres_fdw/postgres_fdw.c
+++ b/contrib/postgres_fdw/postgres_fdw.c
@@ -5808,6 +5808,10 @@ add_paths_with_pathkeys_for_rel(PlannerInfo *root, RelOptInfo *rel,
                                                                                                                  PVC_RECURSE_PLACEHOLDERS));
                }

+               /* Update the cost and width fields if we have added any new columns. */
+               if (!equal(epq_path->pathtarget->exprs, target->exprs))
+                       set_pathtarget_cost_width(root, target);
+
                /*
                 * The passed-in EPQ path is a join path, so it is projection-capable,
                 * but we use create_projection_path() here, so as to avoid modifying


Thanks
Richard