Yes, I believe upsert is the best solution in my case since I don’t want an E1100 error to close the transaction which contains other operations that I don’t want to repeat (in transaction retry logic) or lose.
1 Like