"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

Reply via email to