bug or my ignorance ?

The versions of PostgreSQL I used:
* CVS of Dec. 11, virgin installation without any further changes
* 7.1.3

I have simple SQL functions `testfun()' and `testfun1()' returning values
of the type of relation `T':

=>CREATE TABLE T ( id int8, name text );

=>insert into T VALUES ( 15, 'my name' );

=>CREATE FUNCTION testfun() RETURNS T AS '
'>SELECT 13::int8 as id, ''your name''::text as name;' LANGUAGE sql;

-- or: 'sql' for PostgreSQL 7.1.3

=>CREATE FUNCTION testfun1() RETURNS T AS '
'>SELECT id, name from T;' LANGUAGE sql;

-- or: 'sql' for PostgreSQL 7.1.3

Now I try to call the first function and return the values to the user:

=>select name(r.a) from (select testfun() as a) as r;
ERROR: fmgr_info: function 137857576: cache lookup failed

Does not work. For the second function I first try a simpler call:

=> select r.a from (select testfun1() as a) as r;
a
-----------
137835800
(1 Zeile)

Works but does not help. Retrying it gives two alternating return values:

=> select r.a from (select testfun1() as a) as r;
a
-----------
137857448
(1 Zeile)

=> select r.a from (select testfun1() as a) as r;
a
-----------
137835800
(1 Zeile)

=> select r.a from (select testfun1() as a) as r;
a
-----------
137857448
(1 Zeile)

Now lets look if can return the result of the second function to the
user:

=>select name(r.a) from (select testfun1() as a) as r;
ERROR: fmgr_info: function 137835928: cache lookup failed
=> select name(r.a) from (select testfun1() as a) as r;
ERROR: fmgr_info: function 137857576: cache lookup failed
=>select name(r.a) from (select testfun1() as a) as r;
ERROR: fmgr_info: function 137835928: cache lookup failed
=> select name(r.a) from (select testfun1() as a) as r;
ERROR: fmgr_info: function 137857576: cache lookup failed
=>select name(r.a) from (select testfun1() as a) as r;
ERROR: fmgr_info: function 137835928: cache lookup failed
=> select name(r.a) from (select testfun1() as a) as r;
ERROR: fmgr_info: function 137857576: cache lookup failed
=>select name(r.a) from (select testfun1() as a) as r;
ERROR: fmgr_info: function 137835928: cache lookup failed
=> select name(r.a) from (select testfun1() as a) as r;
ERROR: fmgr_info: function 137857576: cache lookup failed

Unfortunately I cannot.

Is this a sign of insufficient experience from my side or a real bug ?

--
Holger Krug
hkrug(at)rationalizer(dot)com