[BUG] views and functions on relations

From: Alex Pilosov <alex(at)pilosoft(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: [BUG] views and functions on relations
Date: 2001-04-18 03:36:00
Message-ID: Pine.BSO.4.10.10104172328330.17529-100000@spider.pilosoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2001-04-18 04:30:59 Re: plpgsql problem
Previous Message Tatsuo Ishii 2001-04-18 00:59:32 Re: Re: No printable 7.1 docs?