Postgres Pro
Downloads
Home   >   mailing lists

How to restore a Plan from a stored plan text? - Mailing list pgsql-general

From sunpeng
Subject How to restore a Plan from a stored plan text?
Date
Msg-id AANLkTim2HvCaPoJOQFiciwXFSpWJ-GOK3D6NVmJv9TKf@mail.gmail.com
Whole thread Raw
Responses Re: How to restore a Plan from a stored plan text?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Tree view
I've used the following codes to translate the PlannedStmt node to a char string:
PlannedStmt * pltl = (PlannedStmt *) linitial(plantree_list);
Plan *pl = pltl->planTree;
char       *s;
s = nodeToString(pl);
 How to restore from this s to Plan?
  I noticed using func parseNodeString() in /backends/nodes/readfuncs.c can't work, for example there is no codes translating into Agg node, should I write my code to parse this string back into PlannedStmt node?
  Thanks!

pgsql-general by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: How can I use parameters in plain sql
Next
From: Tom Lane
Date:
Subject: Re: How to restore a Plan from a stored plan text?