[BUGS] BUG #2835: Table inheritance and statement level trigger.

[William ZHANG]

The following bug has been logged online:

Bug reference:      2835
Logged by:          William ZHANG
Email address:      [EMAIL PROTECTED]
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