Re: ERROR: fmgr_info: function 0: cache lookup failed

Поиск
Список
Период
Сортировка
От Alex Pilosov
Тема Re: ERROR: fmgr_info: function 0: cache lookup failed
Дата
Msg-id Pine.BSO.4.10.10107041104320.7004-100000@spider.pilosoft.com
обсуждение исходный текст
Ответ на ERROR: fmgr_info: function 0: cache lookup failed  ("Mourad EL HADJ MIMOUNE" <mimoune@ensma.fr>)
Ответы Re: ERROR: fmgr_info: function 0: cache lookup failed  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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.
>
>
>


В списке pgsql-general по дате отправления:

Предыдущее
От: Scott Holmes
Дата:
Сообщение: Re: lo wrappers - still working on it
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Please add to TODO list