3 ms·
How is it different from other isolation levels? It looks like it still fails compared to what upsert would do.
by ash 13y ago
How is it different from other isolation levels? It looks like it still fails compared to what upsert would do.
- jeltz 13y agoOther isolation levels will make the concurrent update find zero rows. Serializable gives an error instead which you reliable can retry the transaction on. They fail in different ways (for serializable a in this case more useful way) which should have been pointed out by the author. It does not seem like he actually tested what isolation levels does or he tested it in a database which does not provide serializable isolation.
- ash 13y agoI think Armin didn't go into isolation levels details because he didn't see a meaningful distinction in the context of emulating upsert.