| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | geoff(at)metalogicplc(dot)com |
| Cc: | "Pgsql-Admin (E-mail)" <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Re: Function problem. |
| Date: | 2003-01-13 15:58:44 |
| Message-ID: | 25405.1042473524@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
"Geoff Ellis" <geoff(at)metalogicplc(dot)com> writes:
> === ERROR: fmgr_info: function 696542: cache lookup failed =====
This is on 7.3? My first guess would have been that you deleted and
recreated the function without recreating the trigger that references
it. But 7.3 should not let you do that.
> I've tried to change the return type to opaque and remove the RETURN 1; But
> if the condition isn't true then I don't have a return.
In an update trigger, you RETURN NEW in the normal case where you want
the update to proceed.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2003-01-13 16:05:07 | Re: PAM Authentication and Postgresql 7.3 |
| Previous Message | codeWarrior | 2003-01-13 15:44:26 | Database logging.... Recycle server logs ??? |