"Mathew Frank" <mathewfrank@qushi.com> writes:
> and the result of a delete query:
> NOTICE: Operation NOT cancelled
> ERROR: fmgr_info: function 1455898: cache lookup failed
> (I was sure I was getting a 'Delete 0' but since my computer has crashed
> since - I`m not sure. Maybe I was getting the above)
> Now before you ask - the trigger was created after the trigger function.
That trigger, maybe, but the fmgr_info failure clearly indicates a
dangling function reference somewhere. Maybe you have other triggers
defined on this table?
Could I interest you in upgrading to 7.3? It's supposed to prevent you
from dropping things that still have references to 'em ...
regards, tom lane