
> 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

Wed, 18 Apr 2001 10:42:04 +0200
Zeugswetter Andreas SB  <ZeugswetterA@wien.spardat.at>
AW: [BUG] views and functions on relations