bug or feature?

Hello there
have some problems on 7.2.3/freebsd

ex.
table1 has 2 columns: id and name
table2 has 3 columns: id, t1_id(references t1(id) on delete cascade) and
'name' field

i got a procedure (plpgsql)

declare i int;
begin
select count(*) into i from table2 where t1_id=123;
raise notice ''rows selected: %'',i;
delete from table1 where id=123;
select count(*) into i from table2 where t1_id=123;
raise notice ''rows selected: %'',i;
end;

the constraint trigger on delete executes ONLY after procedure
completion, but it does not execute right after delete. WHY?

--------------------
Regards,
Eugene Gridasov
mailto:eugene(at)spider(dot)ru