Re: BUG #11094: Does not report error - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #11094: Does not report error
Date
Msg-id 14893.1406757106@sss.pgh.pa.us
Whole thread Raw
In response to BUG #11094: Does not report error  (henart@sofisticat.com.br)
List pgsql-bugs
henart@sofisticat.com.br writes:
> drop type if exists tp_testes cascade;
> create type tp_testes as ( tipo integer);
> create or replace function fnc_testes() returns tp_testes as
> $$
> declare
> t tp_testes;
> x integer;
> begin
>     t.tipo = 1;
>     x = t.valor ;
>     return t;
> end;
> $$
> language plpgsql;

> the above script does not report error when compiling the function, but
> "t.valor" does not exists in type.

It's not expected to give an error; expressions are only syntax-checked
not analyzed for semantic validity.

            regards, tom lane

pgsql-bugs by date:

Previous
From: henart@sofisticat.com.br
Date:
Subject: BUG #11094: Does not report error
Next
From: Bruce Momjian
Date:
Subject: Re: BUG #10991: psql -c ignores my pager settings in ~/.psqlrc