| 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 |