On Wed, Sep 15, 2021, at 10:51 AM, Alvaro Herrera wrote: > In a computer system, alphabet letters are just a different way to > present numbers, so you just choose ASCII letters that match what you > want. You can use "AA_first_trigger", "BB_second_trigger", > "AB_nope_this_is_second" and you'll be fine; you can do > "AAB_oops_really_second" afterwards, and so on. The integer numbering > system doesn't seem very useful/flexible when seen in this light. ... or renumber all trigger positions in a single transaction. I agree that letters are more flexible than numbers but some users are number-oriented.
I'm afraid an extra mechanism to determine the order to fire triggers will confuse programmers if someone decides to use both. Besides that, we have to expend a few cycles to determine the exact trigger execution order. -- Euler Taveira EDB https://www.enterprisedb.com/