Re: plpgsql error - Mailing list pgsql-admin

From Gaetano Mendola
Subject Re: plpgsql error
Date
Msg-id 022501c1bc66$49959370$f8e0fea9@GMENDOLA2
Whole thread Raw
In response to plpgsql error  (s.chava@wcom.com (Srinivasa Rao Chava))
List pgsql-admin
----- Original Message -----
From: "Srinivasa Rao Chava" <s.chava@wcom.com>
To: <pgsql-admin@postgresql.org>
Sent: Friday, February 22, 2002 11:07 PM
Subject: [ADMIN] plpgsql error


> We have upgrade our database from postgresql 7.1.3 to 7.2. Now we are
> getting this error.
> This error appears when the PHP app attempts to insert something
> into a table.  The app was working fine before the upgrade.
>
>
> Error (PGSQL.phtml): ERROR: fmgr_info: function 18015: cache
> lookup failed

You should recreate all the functions.
If the stored procedure A use B and you do some modification to B
you should recreate also A.

Ciao
Gaetano

--
#exclude <windows>
#include <CSRSS>
printf("\t\t\b\b\b\b\b\b");.
printf("\t\t\b\b\b\b\b\b");


pgsql-admin by date:

Previous
From: "Gaetano Mendola"
Date:
Subject: Re: Building binary...
Next
From: Ivan il Terribile
Date:
Subject: Re: passing argument ro a trigger