Keith, thanks for the link! Luckily we can make sure of two things where we use this trigger:
- inserts happen only from 1 connection and 1 thread
- insertion is not time critical
I think with these preconditions the way we set it up still good for the use case. If we are running into concurrency issues ever I am moving it to cron the first time it happens.