Trigger position

Поиск
Список
Период
Сортировка
От Marcos Pegoraro
Тема Trigger position
Дата
Msg-id CAB-JLwY9iLY_4hYemtOJSeG3QbfevcB_rEE0Z4_a=-HXULzGXQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: Trigger position  (Daniel Gustafsson <daniel@yesql.se>)
Re: Trigger position  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Trigger position  (Chapman Flack <chap@anastigmatix.net>)
Список pgsql-hackers
Дерево обсуждения
Hi Hackers, 

Alphabetical order of triggers sometimes makes me write a_Recalc or z_Calc to be sure it´ll be the first or the last trigger with same event of that table

Oracle and SQL Server have FOLLOWS and PRECEDES when defining trigger execution order. Firebird has POSITION, which I like it more.

What do you think about it, do you know an old/abandoned patch that was not committed ?

CREATE TRIGGER RECALC_THAT BEFORE UPDATE POSITION 1 ON ORDERS...
CREATE TRIGGER DO_OTHER_CALC BEFORE UPDATE POSITION 2 ON ORDERS...

Regards, 
Marcos

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

Предыдущее
От: "tanghy.fnst@fujitsu.com"
Дата:
Сообщение: RE: Remove double check when field_name is not NULL in be-secure-openssl.c
Следующее
От: "bucoo@sohu.com"
Дата:
Сообщение: Re: Re: parallel distinct union and aggregate support patch