phantom-read.sql

start transaction isolation level read committed;
SELECT * FROM balances;
  id   | balance 
-------+---------
 Alice |     500
 Bob   |     500
(2 rows)
                                                   
                                                   INSERT INTO
                                                      balances
                                                      (id, balance)
                                                   VALUES
                                                      ('Charlie', 500);

# SELECT * FROM balances;
  id     | balance 
---------+---------
 Alice   |     500
 Bob     |     500
 Charlie |     500
(3 rows)

END;