Trigger position
| От | Marcos Pegoraro |
|---|---|
| Тема | Trigger position |
| Дата | |
| Msg-id | CAB-JLwY9iLY_4hYemtOJSeG3QbfevcB_rEE0Z4_a=-HXULzGXQ@mail.gmail.com обсуждение исходный текст |
| Ответы |
Re: Trigger position
Re: Trigger position Re: Trigger position |
| Список | 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 по дате отправления: