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&#
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
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
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
