Re: fmgr_info error - Mailing list pgsql-general

From Tom Lane
Subject Re: fmgr_info error
Date
Msg-id 9958.958932237@sss.pgh.pa.us
Whole thread Raw
In response to fmgr_info error  (Louis-David Mitterrand <cunctator@apartia.ch>)
List pgsql-general
Louis-David Mitterrand <cunctator@apartia.ch> writes:
> After creating a trigger on an insert I get this error:
> auction=> insert into bid values('mito',3,354);
> NOTICE:  you bid the exact increment of 5
> ERROR:  fmgr_info: function 38667: cache lookup failed
> And the insert is not performed as it should. What does this error mean?

Offhand I'd guess that you deleted and recreated the function, but
didn't delete and recreate the trigger definition, so it's still
pointing at the now-gone version of the function.

This could stand to be cleaned up :-( ... but right now you have
to remake triggers referencing a function whenever you remake
the function.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: crash on \copy
Next
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] Re: MySQL crashme test and PostgreSQL