Re: fmgr_info: function 0: cache lookup failed
От | Booth, Robert |
---|---|
Тема | Re: fmgr_info: function 0: cache lookup failed |
Дата | |
Msg-id | 419D2EB7B461D411A53B00508B69181D037B28C3@sdex02.sd.intuit.com обсуждение исходный текст |
Ответ на | fmgr_info: function 0: cache lookup failed ("Booth, Robert" <Robert_Booth@intuit.com>) |
Список | pgsql-general |
"Booth, Robert" <Robert_Booth@intuit.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
В списке pgsql-general по дате отправления: