3 ms·
I personally find it refreshing to read an example that is not "A deposits $10, B withdraws $10".
by abdusco 3y ago
I personally find it refreshing to read an example that is not "A deposits $10, B withdraws $10".
- heavenlyblue 3y agoThat's becuse this example explains pretty much none of the phenomena that is a result of the isolation levels.
- ivanleoncz 3y agoI'm sorry, but you're wrong... In Postgresql, the default ISOLATION LEVEL is "READ COMMITTED", which by standard, allows "NON-REPEATABLE READ" phenomena. When Transaction on the LEFT is COMMITTED (adding 100 to balance), the Transaction on the RIGHT will add 400 to a balance of 1100, and not to a balance of 1000 (reading NON-REPEATED value). You can do better than leaving this kind of comment that does not contribute in anything. Have good weekend.
- ivanleoncz 3y agoMe too, thanks. Would be nice if you can share some articles that you wrote regarding the matter, so I can have more inspiration. Looking forward to read them and learn from different examples and not the same "boiler plate" example that you can find on any DBMS documentation.