The following bug has been logged online:

Bug reference: 2835
Logged by: William ZHANG
Email address: uniware@zedware.org
PostgreSQL version: 8.2.0
Operating system: Linux
Description: Table inheritance and statement level trigger.
Details:

create language plpgsql;

create table foo(a int);

create table y(a int);
insert into y values(1);

create table yy(b int) inherits(y);

create or replace function func() returns trigger as
$func$
begin
insert into foo values(1);
return null;
end;
$func$ language plpgsql;

create trigger tr after update on y
for each statement execute procedure func();

update y set a = a + 1;

select * from foo;
-- foo is empty, but I think it should have one row.
-- trigger after delete failed, either.
-- trigger after insert is ok.

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend