Re: trigger firing order

Поиск
Список
Период
Сортировка
От Alban Hertroys
Тема Re: trigger firing order
Дата
Msg-id 443B82CD.3060402@magproductions.nl
обсуждение исходный текст
Ответ на trigger firing order  (Hugo <htakada@gmail.com>)
Список pgsql-general
Hugo wrote:
> Hi, how can I tell in which order are triggered different triggers on the
> same table, let me explain ,
> I have three triggers for table A, all of then are intended for "before
> insert" on the table, in ASA I can tell the Db in which order I want the
> triggers to fire, is there an equivalent for postgres ??

They're fired in alphabetical order. I tend to prefix my trigger names
with numbers for that reason ;)

--
Alban Hertroys
alban@magproductions.nl

magproductions b.v.

T: ++31(0)534346874
F: ++31(0)534346876
M:
I: www.magproductions.nl
A: Postbus 416
    7500 AK Enschede

// Integrate Your World //

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

Предыдущее
От: Alban Hertroys
Дата:
Сообщение: Re: Performance UPDATE/INSERT
Следующее
От: "A. Kretschmer"
Дата:
Сообщение: Re: Performance UPDATE/INSERT