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/ ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
