News for hackers. Stuff that matters.
Re:US Attorney Announces $3.36B Cryptocurrency Seizure in Co... by miohtama on Tuesday November 08, 2022 @09:46AM (#33519507)
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/

Re:US Attorney Announces $3.36B Cryptocurrency Seizure in Co... by lmm on Tuesday November 08, 2022 @04:16PM (#33524420)
> 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.