4 ms·
That's becuse this example explains pretty much none of the phenomena that is a result of the isolation levels.
by heavenlyblue 3y ago
That'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.