I believe you need to repeat that update one more time, in case the row wasn’t present during the first update, but was created by another session immediately b

I believe you need to repeat that update one more time, in case the row wasn’t present during the first update, but was created by another session immediately before the insert. Unless you’re in a transaction—then you’d be fine as posted above.