On 3/22/07, Hubert FONGARNAND <informatique.internet@fiducial.fr> 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
restartingthe 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