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 по дате отправления:

Предыдущее
От: Joseph Koenig
Дата:
Сообщение: Re: cannot initdb
Следующее
От: Fran Fabrizio
Дата:
Сообщение: Re: Exclusive Row access???