[BUG] views and functions on relations - Mailing list pgsql-hackers

From Alex Pilosov
Subject [BUG] views and functions on relations
Date
Msg-id Pine.BSO.4.10.10104172328330.17529-100000@spider.pilosoft.com
Whole thread Raw
Responses Re: [BUG] views and functions on relations  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: [BUG] views and functions on relations  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
In latest 7.1 (checked out 2 days ago from CVS), I see following
behaviour:

create table foo(x int4);
create function xx(foo) returns int4 as ' return 0;' language 'plpgsql';
create view tv2 as select xx(foo) from foo;

users=# \d tv2
ERROR:  cache lookup of attribute 0 in relation 21747 failed

(21747 is table oid for foo)

HOWEVER, 'select * from tv2' succeeds (sometimes). Sometimes it fails with
the same error (cache lookup failed).

I think the above should be enough to reproduce this bug.  Any hints? 

-alex




pgsql-hackers by date:

Previous
From: The Hermit Hacker
Date:
Subject: Re: Re: [BUGS] three VERY minor things with 7.1 final
Next
From: Tom Lane
Date:
Subject: Re: plpgsql problem