How to specify trigger execution order under PostgreSQL?
PostgreSQL executes the triggers in alphabetical order by name. So make sure to use names that get them in the order you want. From the docs


  SQL specifies that multiple triggers should be fired in time-of-creation order. PostgreSQL uses name order, which was judged to be more convenient.


BTW your SQL creates the same trigger twice.