Re: foreign join error "variable not found in subplan target list" - Mailing list pgsql-bugs

From Richard Guo
Subject Re: foreign join error "variable not found in subplan target list"
Date
Msg-id CAMbWs4-c8yC-4bfWt0HPgocUNwg7f_ZMSMYgMjm6bSV=PDNX8Q@mail.gmail.com
Whole thread Raw
In response to Re: foreign join error "variable not found in subplan target list"  (Etsuro Fujita <etsuro.fujita@gmail.com>)
Responses Re: foreign join error "variable not found in subplan target list"
Re: foreign join error "variable not found in subplan target list"
List pgsql-bugs

On Mon, Aug 29, 2022 at 2:17 PM Etsuro Fujita <etsuro.fujita@gmail.com> wrote:
One thing I noticed while re-reading the patch is that we should use
create_projection_path() here, to avoid modifying the epq_path in
place, as it is already used for an unsorted join-pushdown path before
we get here.  So I modified the patch as such.  Updated patch
attached.
 
The new change looks reasonable to me as there is other ref to this
epq_path.

I'm looking again on how we adjust the PathTarget, and I think we may
need to update the cost and width fields if there are any new columns
added. Maybe we can leverage set_pathtarget_cost_width for that.

Thanks
Richard

pgsql-bugs by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #17600: Not able to install PostgreSql in my laptop
Next
From: Tom Lane
Date:
Subject: Re: BUG #17598: EXTENSION can no longer create it's own schema! (Create Schema IF NOT EXISTS XXX)