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

Search Discussions

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouppgsql-hackers @
categoriespostgresql
postedApr 18, '01 at 8:42a
activeApr 18, '01 at 8:42a
posts1
users1
websitepostgresql.org...
irc#postgresql

1 user in discussion

Andreas Zeugswetter: 1 post

People

Translate

site design / logo © 2022 Grokbase