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.
Thanks! I suppose th
orruption/loss on my 7.4.2 (fedora core 2 default install). I
found that all machines I've access to are 7.4.2, so I couldn't test it on
later releases. Apologies if it has already been fixed, I didn't find
references to a bug fix for it.
Thanks
/*
* Nicola Pero, November 2004
I've been experiencing data corruption/loss in Postgresql 7.4.2.
I tracked this down to altering tables. After I alter a table, I get data loss
(fields becoming NULL with no reason!) unless I restart immediately the
database server.
The problem shown in your example is simply that the UPDATE in
This is my third attempt at posting to the list ... hopefully it will make
it this time
-- Forwarded message --
Date: Mon, 22 Nov 2004 04:34:22 + (GMT)
From: Nicola Pero <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: Data corruption/loss when altering tables
I&#
