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

On Mon, Nov 22, 2004 at 12:14:30PM -0500, Tom Lane wrote:

> The problem shown in your example is simply that the UPDATE in the
> plpgsql function has cached a plan that applies to the original format
> of the table.  You don't need to restart the server, but you do need to
> start a fresh session to get rid of the obsolete cached plan.

Would LOAD 'plpgsql' work?  Would that cause a fresh compile of the
function the next time it's called, resulting in a new cached plan?
It appears to work that way in simple tests -- are there situations
where that wouldn't work?

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/