Re: Function problem. - Mailing list pgsql-admin

From Tom Lane
Subject Re: Function problem.
Date
Msg-id 25405.1042473524@sss.pgh.pa.us
Whole thread Raw
In response to Function problem.  ("Geoff Ellis" <geoff@metalogicplc.com>)
List pgsql-admin
"Geoff Ellis" <geoff@metalogicplc.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

pgsql-admin by date:

Previous
From: "Rob Abernethy IV"
Date:
Subject: Re: Encrypted Passwords
Next
From: Tom Lane
Date:
Subject: Re: PAM Authentication and Postgresql 7.3