Re: [HACKERS] Function cache regeneration

[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

---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings

Re: [HACKERS] Function cache regeneration

[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 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

[HACKERS] Function cache regeneration

[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 database, and we
don't want nor recreating all of them nor restarting the database... 

Is there a way to do this in SQL?

Thanks

Hubert FONGARNAND
 _ _ __   _     _ __  __ _ 
|  ___(_) __| |_   _  ___(_) __ _| | / ___|| |_ __ _ / _|/ _(_)_ __   __ _ 
| |_  | |/ _` | | | |/ __| |/ _` | | \___ \| __/ _` | |_| |_| | '_ \ / _` |
|  _| | | (_| | |_| | (__| | (_| | |  ___) | || (_| |  _|  _| | | | | (_| |
|_|   |_|\__,_|\__,_|\___|_|\__,_|_| |/ \__\__,_|_| |_| |_|_| |_|\__, |
 |___/ 



___
Ce message et les éventuels documents joints peuvent contenir des informations 
confidentielles.
Au cas où il ne vous serait pas destiné, nous vous remercions de bien vouloir 
le supprimer et en aviser immédiatement l'expéditeur. Toute utilisation de ce 
message non conforme à sa destination, toute diffusion ou publication, totale 
ou partielle et quel qu'en soit le moyen est formellement interdite.
Les communications sur internet n'étant pas sécurisées, l'intégrité de ce 
message n'est pas assurée et la société émettrice ne peut être tenue pour 
responsable de son contenu.