Thread: plpgsql error

plpgsql error

From
s.chava@wcom.com (Srinivasa Rao Chava)
Date:
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

Thanks for any  help
chava

Re: plpgsql error

From
"Gaetano Mendola"
Date:
----- 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");