ERROR: fmgr_info: function 0: cache lookup failed - Mailing list pgsql-general

From Mourad EL HADJ MIMOUNE
Subject ERROR: fmgr_info: function 0: cache lookup failed
Date
Msg-id 001501c1046f$197dcb80$71a337c1@ensma.fr
Whole thread Raw
Responses Re: ERROR: fmgr_info: function 0: cache lookup failed
List pgsql-general
Hi,
I want retrieve ROW of tables by their OID,
to do thise I made as folowing :
CREATE TABLE tab1 (X int4, Y varchar);
CREATE
 
CREATE FUNCTION tabrecord (OID) returns RECORD AS 'BEGIN RETURN(SELECT *
 FROM tab1 WHERE OID = $1) END;' language 'plpgsql';
NOTICE:  ProcedureCreate: type 'record' is not yet defined
NOTICE:  ProcedureCreate: type 'record' is not yet defined
CREATE
 
select tabrecord (2542 :: oid);
ERROR:  fmgr_info: function 0: cache lookup failed
ERROR:  fmgr_info: function 0: cache lookup failed
 
could you help me to solve this problem please,
Mourad.
 
 

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: Determining scan types
Next
From: "markus jais"
Date:
Subject: which Python interface