Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- IN FIRST CONNECTION
- CREATE TABLE test (id PRIMARY KEY);
- BEGIN;
- SELECT * FROM test; -- 0 rows. Snapshot taken.
- -- IN SECOND CONNECTION
- INSERT INTO ttt VALUES 1; -- Here autocommit is on.
- -- AGAIN IN FIRST CONNECTION
- SELECT * FROM test; -- 0 rows.
- SELECT * FROM test FOR UPDATE; -- 1 row!!!!!
- COMMIT;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement