On Mon, Nov 22, 2004 at 06:26:09PM +0000, Nicola Pero wrote:
> Is there a way to explictly flush cached plans ? Is there a way to
> prevent the caching of the plan in the stored procedure ?
You can prevent plan caching in PL/pgSQL by using EXECUTE. See the
"Executing Dynamic Commands" section in the PL/pgSQL chapter of the
documentation.
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/