BUG #2835: Table inheritance and statement level trigger. - Mailing list pgsql-bugs

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.