> 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 ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html