| 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: | Whole Thread | Raw Message | 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 |