Trigger execution order
-
Suppose I have 3 or 4 triggers on a table for UPDATE. Is there a way to control the execution order of them?
Excellence is not an act, but a habit!
Aristotle
-
Suppose I have 3 or 4 triggers on a table for UPDATE. Is there a way to control the execution order of them?
Excellence is not an act, but a habit!
Aristotle
Not really, not on one table. I assume that you are talking about the same type of trigger here. If they are different trigger types, e.g. DELETE and INSERT, then they are fired based on the operation performed on the table. Why would you want to have multiple triggers fired anyway? I'm not sure I can see what benefit you would get out of this design.
the last thing I want to see is some pasty-faced geek with skin so pale that it's almost translucent trying to bump parts with a partner - John Simmons / outlaw programmer
Deja View - the feeling that you've seen this post before. -
Not really, not on one table. I assume that you are talking about the same type of trigger here. If they are different trigger types, e.g. DELETE and INSERT, then they are fired based on the operation performed on the table. Why would you want to have multiple triggers fired anyway? I'm not sure I can see what benefit you would get out of this design.
the last thing I want to see is some pasty-faced geek with skin so pale that it's almost translucent trying to bump parts with a partner - John Simmons / outlaw programmer
Deja View - the feeling that you've seen this post before.Because, ON UPDATE i need to do several different things on the table. some are logging things. some are denormalization for performance. some are maintenance issues... but I need then in certain order. I know, i stick them all in one trigger... But still, I was wondering if it could be done in 3 triggers
Excellence is not an act, but a habit!
Aristotle