Re: Delete triggers - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Delete triggers
Date
Msg-id 16761.1049414122@sss.pgh.pa.us
Whole thread Raw
In response to Re: Delete triggers  ("Mathew Frank" <mathewfrank@qushi.com>)
List pgsql-bugs
"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

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: 'query was cancelled' - depending on search pattern
Next
From: pgsql-bugs@postgresql.org
Date:
Subject: Bug #933: Too many inserts crash server