ERROR: fmgr_info: function 0: cache lookup failed

From: "Mourad EL HADJ MIMOUNE" <mimoune(at)ensma(dot)fr>
To: <pgsql-general(at)postgresql(dot)org>
Subject: ERROR: fmgr_info: function 0: cache lookup failed
Date: 2001-07-04 09:52:55
Message-ID: 001501c1046f$197dcb80$71a337c1@ensma.fr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message markus jais 2001-07-04 10:19:18 which Python interface
Previous Message Nico Vaes 2001-07-04 07:35:54 Databases in Belgium