From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | "Mathew Frank" <mathewfrank(at)qushi(dot)com> |
Cc: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: Delete triggers |
Date: | 2003-04-03 23:55:22 |
Message-ID: | 16761.1049414122@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
"Mathew Frank" <mathewfrank(at)qushi(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | drdave | 2003-04-04 01:33:13 | Re: 'query was cancelled' - depending on search pattern |
Previous Message | Tom Lane | 2003-04-03 23:50:55 | Re: 'query was cancelled' - depending on search pattern |