BUG #2835: Table inheritance and statement level trigger.

Поиск
Список
Период
Сортировка
От William ZHANG
Тема BUG #2835: Table inheritance and statement level trigger.
Дата
Msg-id 200612180817.kBI8HsNL091720@wwwmaster.postgresql.org
обсуждение исходный текст
Список 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.

В списке pgsql-bugs по дате отправления:

Предыдущее
От: "Kevin Grittner"
Дата:
Сообщение: Re: BUG #2830: Wrong results for prepared statements
Следующее
От: "Albert Cervera i Areny"
Дата:
Сообщение: BUG #2836: SPI_execute_plan failed on pl/pgsql function that worked on 8.1