fmgr_info error

Started by Louis-David Mitterrandalmost 26 years ago2 messagesgeneral
Jump to latest
#1Louis-David Mitterrand
cunctator@apartia.ch

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?

TIA

--
Louis-David Mitterrand - ldm@apartia.org - http://www.apartia.fr

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Louis-David Mitterrand (#1)
Re: fmgr_info error

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