AW: [BUG] views and functions on relations

Поиск
Список
Период
Сортировка
От Zeugswetter Andreas SB
Тема AW: [BUG] views and functions on relations
Дата
Msg-id 11C1E6749A55D411A9670001FA687963368292@sdexcsrv1.f000.d0188.sd.spardat.at
обсуждение исходный текст
Список 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;

regression=# create function xx(foo) returns int4 as ' return 0;' language 'plpgsql';
CREATE

regression=# \d tv2
ERROR:  cache lookup of attribute 0 in relation 145121 failed

Above function does not compile:
regression=# select * from tv2;
NOTICE:  plpgsql: ERROR during compile of xx near line 1
ERROR:  parse error at or near "return"

Try to see whether the problem persists with a valid function.

Andreas


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

Предыдущее
От: darcy@druid.net (D'Arcy J.M. Cain)
Дата:
Сообщение: Re: Another news story in need of 'enlightenment'
Следующее
От: Karel Zak
Дата:
Сообщение: Re: Strange behaviour of to_date()