Re: fmgr_info: function 0: cache lookup failed

"Booth, Robert" <Robert_Booth(at)intuit(dot)com> writes:
>> CREATE FUNCTION MsAccessBool (bool, int4) RETURNS BOOL AS ...

>> CREATE OPERATOR = (
>> LEFTARG = BOOL,
>> RIGHTARG = INT4,
>> PROCEDURE = MsAccessBool,
>> COMMUTATOR = '=',
>> NEGATOR = '<>',
>> RESTRICT = EQSEL,
>> JOIN = EQJOINSEL);

> So I did this, and now I'm getting the "fmgr_info: function 0: cache
lookup
> failed" message.

> You are telling the system that there will be an int4 = bool operator
> (the commutator) as well as a bool <> int4 operator (the negator).
> If you are not going to supply same, don't declare that you will.

> The error message could be more helpful, perhaps :-(

> regards, tom lane

So are you telling me that I need to create another OPERATOR?

And if so would this be the correct syntax?

CREATE OPERATOR <> (
LEFTARG = BOOL,
RIGHTARG = INT4,
PROCEDURE = MsAccessBool,
COMMUTATOR = '=',
NEGATOR = '<>',
RESTRICT = EQSEL,
JOIN = EQJOINSEL);

Rob