"Geoff Ellis" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org