Re: plpgsql error

From: "Gaetano Mendola" <mendola(at)bigfoot(dot)com>
To: "Srinivasa Rao Chava" <s(dot)chava(at)wcom(dot)com>, <pgsql-admin(at)postgresql(dot)org>
Subject: Re: plpgsql error
Date: 2002-02-23 12:33:24
Message-ID: 022501c1bc66$49959370$f8e0fea9@GMENDOLA2
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


----- Original Message -----
From: "Srinivasa Rao Chava" <s(dot)chava(at)wcom(dot)com>
To: <pgsql-admin(at)postgresql(dot)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");

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Ivan il Terribile 2002-02-23 12:51:10 Re: passing argument ro a trigger
Previous Message Gaetano Mendola 2002-02-23 12:30:45 Re: Building binary...