The order of the execution is undetermined. You can find what it is today, but that doesn't mean it won't change in the future. Customers cannot assume any specific order.
If you have a set of actions you want to execute than create a stored procedure and execute it on a trigger.
There is not reasonable rationale to assume a certain order on independent triggers.
If the actions are dependent then they should be executed together.
Regards.
------------------------------
FERNANDO NUNES
------------------------------
Original Message:
Sent: Wed September 11, 2019 09:41 AM
From: Art Kagel
Subject: Trigger Order
I've never testing this, but I strongly suspect that triggers are fired in the order they are created, ie they are selected from systriggers ORDER BY trigid ...
Easy enough to test. Create two update triggers on different column on a table that write to a logging table that has a serial column so that the record written identifies which trigger it was that wrote it. Then try adding the two triggers in different orders and see what happens.
------------------------------
Art Kagel
Original Message:
Sent: Tue September 10, 2019 03:44 PM
From: Dave Baligo
Subject: Trigger Order
Hi,
We are running Informix 12.10.FC9W1 on Solaris. We have multiple insert triggers on a table. Is there a way to enforce that the triggers should get executed in a particular order?
Thank You,
--Dave
------------------------------
Dave Baligo
------------------------------
#Informix