Trigger question

Поиск
Список
Период
Сортировка
От Daniel Schuchardt
Тема Trigger question
Дата
Msg-id cgkcgr$2k25$1@news.hub.org
обсуждение исходный текст
Ответы Re: Trigger question  (Daniel Schuchardt <daniel_schuchardt@web.de>)
Список pgsql-general
Hi list,

i'm a bit confused. I have a table with a trigger after insert. It is
possible that this trigger will do inserts in the same table, but is the
after insert trigger fired again in this case? (I would need this)

e.g.

USER INSERT

BEFORE TRIGGER
AFTER TRIGGER

->DECIDES TO INSERT X ROWS IN THE SAME TABLE

->BEFORE TRIGGER (this one is fired for each row the after trigger inserts)

->AFTER TRIGGER AGAIN???? FOR EACH ROW THE AFTER TRIGGER INSERTED

thnx a lot.
Daniel

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

Предыдущее
От: Michal Hlavac
Дата:
Сообщение: Re: Stored procedure failure
Следующее
От: Richard Huxton
Дата:
Сообщение: Re: ltree bug handling nulls (was Stored procedure failure)