3 ms·
Your comment is not true for high quality databases like PostgrSQL. Check-and-set just works on the correct isolation level. There is no isolation, your transac
by miohtama 4y ago
Your comment is not true for high quality databases like PostgrSQL. Check-and-set just works on the correct isolation level. There is no isolation, your transaction will fail and be rolled back.
If you are new to the subject there are extensive reports available from Jepsten, one of the leading names in distributed system and ACID anomaly testing and research.
https://jepsen.io/ https://jepsen.io/
- lmm 4y ago> Check-and-set just works on the correct isolation level. Which is not the default one. > There is no isolation, your transaction will fail and be rolled back. How so? Isn't it more likely you'll silently corrupt your data? Even if it does fail noisily, this is a condition you're unlikely to hit in testing, so you'll probably be dealing with it in production.