Re: Order of update triggers

Поиск
Список
Период
Сортировка
От Rob Richardson
Тема Re: Order of update triggers
Дата
Msg-id 67D108EDFAD3C148A593E6ED7DCB4BBDFA355F@RADCONWIN2K8PDC.radcon.local
обсуждение исходный текст
Ответ на Re: Order of update triggers  ("Jean-Yves F. Barbier" <12ukwn@gmail.com>)
Ответы Re: Order of update triggers  ("Jean-Yves F. Barbier" <12ukwn@gmail.com>)
Список pgsql-novice
I have confirmed that in my case, the delete trigger is happening before the update trigger, presumably because it is
happeningin alphabetic order as was stated earlier.  But since the data being used by the update trigger comes from the
'new'object instead of from the current contents of the table, it does not matter that the underlying record may have
alreadybeen deleted.  (Of course, all triggers are fired within a single transaction, and inside a transaction, terms
like"before", "after" and "already" are effectively meaningless.  Right?) 

RobR


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

Предыдущее
От: "Jean-Yves F. Barbier"
Дата:
Сообщение: Re: Order of update triggers
Следующее
От: Angus
Дата:
Сообщение: Install & Launch PgAdmin on CentOS 6.2 with PostgreSQL 8.4.9