Postgres Pro
Downloads
Home   >   mailing lists

Re: Data corruption/loss when altering tables (fwd) - Mailing list pgsql-bugs

From Michael Fuhr
Subject Re: Data corruption/loss when altering tables (fwd)
Date
Msg-id 20041122190711.GA81770@winnie.fuhr.org
Whole thread Raw
In response to Re: Data corruption/loss when altering tables (fwd)  (Nicola Pero <n.pero@mi.flashnet.it>)
Responses Re: Data corruption/loss when altering tables (fwd)
List pgsql-bugs
Tree view 
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/

pgsql-bugs by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: Data corruption/loss when altering tables (fwd)
Next
From: Aaron Hillegass
Date:
Subject: pg_ctl -w start does not know that it has started postmaster