Re: Cache lookup error

> -----Original Message-----
> From: Ramya Asokan [mailto:ramya(dot)asokan(at)wdc(dot)greenpeace(dot)org]
> Sent: 24 May 2002 21:01
> To: pgsql-admin(at)postgresql(dot)org; pgadmin-support(at)postgresql(dot)org
> Subject: [pgadmin-support] Cache lookup error
>
>
> Hi,
> I created a function and a trigger - I then dropped them and
> created the same function and trigger with a different name,
> but i keep getting the error : cache lookup failed. I don't
> know what this means, and would be very grateful if you can
> help me out.

This error may occur if you dropped your function, but not the trigger
(or the trigger failed to drop for some reason). The trigger is still
firing but the cache lookup of the function is failing because it has
gone. This could also happen if your function is dependent on another
function that has since been dropped.

I would suggest first checking that the original trigger was dropped
correctly(and dropping it if not), and if that doesn't solve the
problem, dropping and recreating all the objects again, making sure that
all the dependencies are satisfied.

Regards, Dave.