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

Поиск
Список
Период
Сортировка
От Konstantin Nikiforov
Тема Re: Bug: table inheritance. Trigger before DELETE for each statement is ignored
Дата
Msg-id 20101203103547.48943eea@avers
обсуждение исходный текст
Ответ на Re: Bug: table inheritance. Trigger before DELETE for each statement is ignored  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
Дерево обсуждения 
Ok, thanks, roger you.
But one question still cause my misunderstanding:
> > 2. If i create trigger FOR EACH STATEMENT, it will work ok for
> > insert, update and delete.
>=20
> You mean FOR EACH ROW, no?

Yes, confused. FOR EACH ROW.

"FOR EACH ROW"-trigger successfully fires in inherited
table "xtest_inh", then we deleteting row from PARENT table "xtest".
=20
This behaviour conflicts with:

> So the designed behavior is
> that only the named target table has its statement triggers fired.

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

Предыдущее
От: Konstantin Nikiforov
Дата:
Сообщение: Re: Bug: table inheritance. Trigger before DELETE for each statement is ignored
Следующее
От: Euler Taveira de Oliveira
Дата:
Сообщение: Re: Problems with max_connections parameter