Re: Cache Lookup failed Error - while using Triggers

Hi Joe,

Thanks Alot,

I followed how u said, then if I execute the same insert statement the
following error is occuring.

ERROR : Parse error at or near "empname"

As I Check I didnot find any parse error there. This is error is occuring if
and only if 'emp' table have trigger. Is there any problem in function
'aa_emp_stamp()'

Regards,
Sreedhar
----- Original Message -----
From: "Joe Conway" <mail@joeconway.com>
To: "shreedhar" <shreedhar@lucidindia.net>
Cc: "Postgres" <pgsql-admin@postgresql.org>
Sent: Wednesday, September 11, 2002 10:38 AM
Subject: Re: [ADMIN] Cache Lookup failed Error - while using Triggers


> shreedhar wrote:
> > I am getting the following Error
> >
> > 'ERROR : fmgr_info : function 1059155 : cahce lookup failed
> > PostgreSQL status : PGRES_FATAL_ERROR'
> >
> > Can any body tell that what is this error. How can I solve this.
> >
>
> If you drop and recreate the function, you need to also drop and recreate
the
> trigger. Did you do the former without the latter?
>
> Joe