PlannerInfo Structure

Started by Ana Carolina Brito de Almeidaover 16 years ago2 messages

Hi all,

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)?

Thanks,
Ana Carolina

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Ana Carolina Brito de Almeida (#1)
Re: PlannerInfo Structure

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