Re: PlannerInfo Structure - Mailing list pgsql-hackers

From Tom Lane
Subject Re: PlannerInfo Structure
Date
Msg-id 8572.1244655905@sss.pgh.pa.us
Whole thread Raw
In response to PlannerInfo Structure  (Ana Carolina Brito de Almeida <anacrl@ig.com.br>)
List pgsql-hackers
Ana Carolina Brito de Almeida <anacrl@ig.com.br> writes:
> I created a function which needs build or find a relation (RelOptInfo).
> The build is ok.
> On the other hand, I can't find the relation. I have all informations that
> pg_plan_query has: querytree (Query), cursorOptions (int),
> boundParams(ParamListInfo) and plan (PlannedStmt).
> So, how can I take RelOptInfo by these parameters?
> I thought in use "find_base_rel", but it needs the PlannerInfo structure
> that I don't have.
> Do you recommend another function? How can I find PlannerInfo with
> parameters that I have (Eg.: PlannedStmt)?

You can't; it's a transient structure and it's already gone after the
planner returns.  If you are plugging into the planning process
somewhere, it should be getting passed to you, but the data isn't
kept around after the plan is completed.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Resolving 8.4 open items
Next
From: Magnus Hagander
Date:
Subject: Re: Resolving 8.4 open items