fmgr_info: function 0: cache lookup failed
I'm porting an Access database to Postgres but keeping Access as the client.
I have been having problems with checkboxes and so I did some searching and
came across information that told me to uncheck Bools as Char in the ODBC
driver settings, I did that and started getting the following error:
ERROR: Unable to identify an operator '=' for types 'boolean' and 'integer'
You will have to retype this query using an explicit cast
So after some more searching I came across a message talking about adding
the function and an operator below to handle this problem:
CREATE FUNCTION MsAccessBool (bool, int4) RETURNS BOOL AS '
BEGIN
IF $1 IS NULL THEN
RETURN NULL;
END IF;
IF $1 IS TRUE THEN
IF $2 <> 0 THEN
RETURN TRUE;
END IF;
ELSE
IF $2 = 0 THEN
RETURN TRUE;
END IF
END IF;
RETURN FALSE;
END ;
' LANGUAGE 'plpgsql';
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. I've again done some looking and the only thing I've found
is a message that talks about the oprrest and oprjoin fields in the
pg_operator table, but not what I need to do with them. Any help would be
greatly appreciated.
Thanks,
Rob
"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
--- "Booth, Robert" <Robert_Booth@intuit.com> wrote:I'm porting an Access database to Postgres but
keeping Access as the client....
...So I did this, and now I'm getting the
"fmgr_info:
function 0: cache lookup
failed" message. ...Any help would be
greatly appreciated.Thanks,
Rob
Your problem, as I see, could be fixed following the
instructions bellow:
http://techdocs.postgresql.org/errors.php#plpgsqlinit_fcache
Juliano S. Ignacio
jsignacio@yahoo.com
__________________________________________________
Do You Yahoo!?
Try FREE Yahoo! Mail - the world's greatest free email!
http://mail.yahoo.com/
"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
Import Notes
Resolved by subject fallback