[BUG] views and functions on relations

Поиск
Список
Период
Сортировка
От Alex Pilosov
Тема [BUG] views and functions on relations
Дата
Msg-id Pine.BSO.4.10.10104172328330.17529-100000@spider.pilosoft.com
обсуждение исходный текст
Ответы 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>)
Список 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 по дате отправления:

Предыдущее
От: The Hermit Hacker
Дата:
Сообщение: Re: Re: [BUGS] three VERY minor things with 7.1 final
Следующее
От: Tom Lane
Дата:
Сообщение: Re: plpgsql problem