Help! Lost functions - Mailing list pgsql-novice

From John Sklavounos
Subject Help! Lost functions
Date
Msg-id 200212031657.AA1149698226@mail.cofs.com
Whole thread Raw
List pgsql-novice
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


pgsql-novice by date:

Previous
From: "Warren Massengill"
Date:
Subject: Re: Copy entire file as one field
Next
From: Oliver Elphick
Date:
Subject: Re: Copy entire file as one field