I think it would be more preferable to have the triggers execute in a
clearly defined order.
And the only available order I can think of is the order of definition.
But currently I don't have a clear need.
I will report if I run into one.
One more thought about the triggers...
Currently I can not use the syntax
CREATE TRIGGER TRIG_NAME BEFORE
INSERT,UPDATE,DELETE <-- This is the important part
ON TEST FOR EACH ROW CALL "MyTrigger"
because the trigger type is given in init method.
So I don't know what type of trigger I am dealing with in the fire method.
Therefore it would be better to get the type in the fire method.
But that would break the API so I understand that this change is not
something you would like to do.
Just a thought for version 2.0 :-)
- rami
On 20.5.2010 23:06, Thomas Mueller wrote:
Hi,
Are triggers always executed in the order they are created?
I'm not sure what the current implementation does, but in general if
there are multiple triggers, the order in which they are called is
undefined. I will document that.
Regards,
Thomas
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en.
