BUG #6531: integrity constraint failure

The following bug has been logged on the website:

Bug reference: 6531
Logged by: Claudio Oliveira
Email address: claudiomsi(at)hotmail(dot)com
PostgreSQL version: 9.1.3
Operating system: windows 7
Description:

Hello,

It would be a BUG.

Please run by separate blocks for the comment.

One to One Works.

By not blocks.

-----------------------------------------------------------------------

create table mestre (chave serial primary key, descricao varchar(50));

create table detalhe (chave serial primary key,
mestre integer references mestre(chave) ON DELETE
CASCADE,
valor numeric);

CREATE OR REPLACE FUNCTION ftrig_detalhe()
RETURNS trigger AS
$BODY$
begin
return null;
end;$BODY$
LANGUAGE 'plpgsql' VOLATILE;

---------------------------------------------------------------------
insert into mestre (chave, descricao) values (1, 'TESTE');
insert into detalhe (chave, mestre, valor) values (1, 1, 10);
select * from detalhe d left join mestre m on m.chave = d.mestre;
---------------------------------------------------------------------
delete from mestre where chave = 1;
select * from detalhe d left join mestre m on m.chave = d.mestre;
---------------------------------------------------------------------

CREATE TRIGGER tdetalhe
before DELETE
ON detalhe
FOR EACH ROW
EXECUTE PROCEDURE ftrig_detalhe();

---------------------------------------------------------------------
insert into mestre (chave, descricao) values (1, 'TESTE');
insert into detalhe (chave, mestre, valor) values (1, 1, 10);
select * from detalhe d left join mestre m on m.chave = d.mestre;
---------------------------------------------------------------------
delete from mestre where chave = 1;
select * from detalhe d left join mestre m on m.chave = d.mestre;
---------------------------------------------------------------------