When are trigger function results committed

Поиск
Список
Период
Сортировка
От Keith Worthington
Тема When are trigger function results committed
Дата
Msg-id 20050309150847.M6609@narrowpathinc.com
обсуждение исходный текст
Ответы Re: When are trigger function results committed  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-novice
Hi All,

I have a table with three trigger functions on it.  After insert the first
(defined alphabetically) trigger fires and performs its task.  Then the second
and finally the third triggers fire.  It does not appear that the second
trigger can see the results of the third trigger and the third cannot see the
results of the forth trigger.  Is this the expected behavior?  If so can
anyone suggest how I can make the functions see the previous results?

Kind Regards,
Keith

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

Предыдущее
От: Bruno Wolff III
Дата:
Сообщение: Re: Foreign key error, please help.
Следующее
От: Tom Lane
Дата:
Сообщение: Re: When are trigger function results committed