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 failed...
 In fact we've more than 100 functions in our intranet database, and we don't 
want nor recreating all of them nor restarting the database...

 Is there a way to do this in SQL?


there is technique to recompile pl/pgsql command, etc taking the
function name or oid i think. search the archives...

plan invalidation is coming to 8.3 i think.

merlin

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

              http://archives.postgresql.org

Reply via email to