Re: [HACKERS] Function cache regeneration

2007-03-22 Thread Tom Lane
Hubert FONGARNAND <[EMAIL PROTECTED]> writes: > I'm looking for a way to regenerate the plpgsql function cache, without > CREATE OR REPLACE function or restarting database... You don't have to restart the whole database, just start fresh connections. regards, tom lane ---

Re: [HACKERS] Function cache regeneration

2007-03-22 Thread Merlin Moncure
On 3/22/07, Hubert FONGARNAND <[EMAIL PROTECTED]> wrote: Hi, I'm looking for a way to regenerate the plpgsql function cache, without CREATE OR REPLACE function or restarting database... Sometimes, tables could be dropped and recreated, and then all our function working on these tables fail

[HACKERS] Function cache regeneration

2007-03-22 Thread Hubert FONGARNAND
Hi, I'm looking for a way to regenerate the plpgsql function cache, without CREATE OR REPLACE function or restarting database... Sometimes, tables could be dropped and recreated, and then all our function working on these tables failed... In fact we've more than 100 functions in our intranet datab