[GENERAL] fmgr_info error

2000-05-21 Thread Louis-David Mitterrand

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 - [EMAIL PROTECTED] - http://www.apartia.fr



Re: [GENERAL] fmgr_info error

2000-05-21 Thread Tom Lane

Louis-David Mitterrand [EMAIL PROTECTED] 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