Re: Data corruption/loss when altering tables (fwd)

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Nicola Pero <n(dot)pero(at)mi(dot)flashnet(dot)it>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: Data corruption/loss when altering tables (fwd)
Date: 2004-11-22 19:07:11
Message-ID: 20041122190711.GA81770@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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/

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message David B 2004-11-22 20:20:39 Getting weird results with unicode table...
Previous Message Nicola Pero 2004-11-22 18:26:09 Re: Data corruption/loss when altering tables (fwd)