-- 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;