From: | Alex Pilosov <alex(at)pilosoft(dot)com> |
---|---|
To: | Mourad EL HADJ MIMOUNE <mimoune(at)ensma(dot)fr> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: ERROR: fmgr_info: function 0: cache lookup failed |
Date: | 2001-07-04 15:05:43 |
Message-ID: | Pine.BSO.4.10.10107041104320.7004-100000@spider.pilosoft.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Currently, you must do:
CREATE FUNCTION tabrecord (OID) returns tab1 AS '...
But it wouldn't help you much since the only thing you can do with this
function is:
select x(tabrecord(2542)),y(tabrecord(2542))
On Wed, 4 Jul 2001, Mourad EL HADJ MIMOUNE wrote:
> 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.
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Ryan Mahoney | 2001-07-04 15:35:11 | pgsql and sql-relay |
Previous Message | Bruce Momjian | 2001-07-04 14:56:57 | Re: Please add to TODO list |