Re: Bug: table inheritance. Trigger before DELETE for each statement is ignored

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Bug: table inheritance. Trigger before DELETE for each statement is ignored
Дата
Msg-id 26429.1291391875@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Bug: table inheritance. Trigger before DELETE for each statement is ignored  (Konstantin Nikiforov <helllamer@gmail.com>)
Список pgsql-bugs
Konstantin Nikiforov <helllamer@gmail.com> writes:
> Also another bug and usecase connected with subj.
> It creates parent table "xtest", inherited table "xtest_inh" with
> some data, and a trigger BEFORE INSERT/UPDATE/DELETE on table "xtest".
> After, it deletes one row.

I think you fundamentally misunderstand how triggers on inherited tables
work.  A row-level trigger is fired for events on rows *in its table*.

            regards, tom lane

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

Предыдущее
От: Heikki Linnakangas
Дата:
Сообщение: Re:
Следующее
От: daniel
Дата:
Сообщение: pgcrypto bug or my brain?