BUG #11094: Does not report error

From: henart(at)sofisticat(dot)com(dot)br
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #11094: Does not report error
Date: 2014-07-30 21:04:17
Message-ID: 20140730210417.2708.97216@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 11094
Logged by: Henart
Email address: henart(at)sofisticat(dot)com(dot)br
PostgreSQL version: 9.3.4
Operating system: CentOS 6.5
Description:

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.
if i use

t.valor = 1;

error occurs when compiling the function. in earlier versions (such as 8.4),
SQL STATE 42703 error occurs.

Tks

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2014-07-30 21:51:46 Re: BUG #11094: Does not report error
Previous Message vipivoxa 2014-07-30 18:57:43 BUG #11093: login with cyrilic input language make pgAdmin to blow out instead of the wrong password message.