Re: fmgr_info: function 20071: cache lookup failed - Mailing list pgsql-hackers

On Thu, 21 Feb 2002, Jean-Michel POURE wrote:

> Dear Stephan ,
>
> > Is 20071 the oid of the function in question?
> Yes, as from the error message. It is quite surprising.

Wanted to be sure it wasn't some other function that might be being
referenced therein.

> > Can you give a standalone example that gives the error?
> After updating a PLpgSQL function of a trigger on table foo with CREATE OR
> REPLACE using latest version of pgAdmin2.
>
> If I run "UPDATE TABLE foo SET foo_timestamp = 'now' WHERE .... sql clause"
> will return an error. It seems to be a migration problem.

Hmm, I just did a simple test of a before insert/update trigger and
updating with create or replace from psql and didn't have a problem.  Can
you give the tables/functions involved?