AW: [BUG] views and functions on relations

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

Browse pgsql-hackers by date

  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