I would like to disable alphabetical order of triggers firing. Is it possible?

The reason I need this is to show in my studies why it is important to take care of triggers' execution order. However, I cannot find any way to disable this order and allow triggers race.

  • as I understand - it is fundamentals and no any methods to change this – a_vlad Nov 19 '16 at 19:50
  • Good question, but it's not possible. For your studies, I can recommend creating a test case using a BEFORE and AFTER trigger, and swapping them round manually to prove your point. It's easy to come up with situations that'll go horribly wrong if they're the wrong way round :) – Philᵀᴹ Nov 19 '16 at 23:11
  • 3
    can't use some prefix like a00_, a01_, a02_ to fix the order? – McNets Nov 20 '16 at 0:05
  • fixed order is still not race... – Piwniczne Nov 21 '16 at 15:39

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.