Re: cache lookup failed ???? What is it ???!!!

J.Fernando Moyano writes:

> I can't execute this SQL query:  DELETE FROM piezas WHERE ord_mec = '01-001'
> I get:  ERROR: fmgr_info: function 39816: cache lookup failed

You dropped the function that is referenced by the trigger and recreated
one by the same name.  The system keeps track of functions by oid, not by
name, so the trigger doesn't find the function anymore.  Solution:  Drop
and re-create the trigger.

-- 
Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter