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
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. |