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

From Tom Lane
Subject Re: How to restore a Plan from a stored plan text?
Date
Msg-id 7009.1283575396@sss.pgh.pa.us
Whole thread Raw
In response to How to restore a Plan from a stored plan text?  (sunpeng <bluevaley@gmail.com>)
Responses Re: How to restore a Plan from a stored plan text?  (sunpeng <bluevaley@gmail.com>)
List pgsql-general
sunpeng <bluevaley@gmail.com> writes:
> 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?

You can't.  The fact that there's nodeToString support for all Plan node
types is only intended as a debugging aid --- there's no intention that
it should be possible to serialize and deserialize plans this way.

You didn't say what it is you actually hope to accomplish, but maybe
asking plancache.c to store the plan for you would do.

            regards, tom lane

pgsql-general by date:

Previous
From: sunpeng
Date:
Subject: How to restore a Plan from a stored plan text?
Next
From: sunpeng
Date:
Subject: Re: How to restore a Plan from a stored plan text?