Thread: Help! Lost functions

Help! Lost functions

From
"John Sklavounos"
Date:
Hello,

We are running PostgreSQL v7.2 on a Red Hat v7.3 server.

The problem we're having is that the database lost the installed PLPGSQL handler.  The symptom we were having was that
allfunctions began failing for "cache lookup failed".  We then reinstalled it using the createlang command.  This had
theunfortunate side effect of wiping out all our functions in the database.  

Since we have no backup (I know, I know - there is a management type whipping me right now) I am hoping someone can
helpme figure out where the missing functions might be in the raw file...  

Please help!

TIA, John