From: | Zeugswetter Andreas SB <ZeugswetterA(at)wien(dot)spardat(dot)at> |
---|---|
To: | "'Alex Pilosov'" <alex(at)pilosoft(dot)com>, pgsql-hackers(at)postgresql(dot)org |
Subject: | AW: [BUG] views and functions on relations |
Date: | 2001-04-18 08:42:04 |
Message-ID: | 11C1E6749A55D411A9670001FA687963368292@sdexcsrv1.f000.d0188.sd.spardat.at |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Karel Zak | 2001-04-18 08:47:04 | Re: Strange behaviour of to_date() |
Previous Message | Zeugswetter Andreas SB | 2001-04-18 08:12:34 | AW: Re: timeout on lock feature |