-- Процесс A BEGIN; SELECT * FROM orders WHERE id = 1 FOR UPDATE; SELECT * FROM orders WHERE id = 2 FOR UPDATE; -- Процесс B (в это же время) BEGIN; SELECT * FROM orders WHERE id = 2 FOR UPDATE; SELECT * FROM orders WHERE id = 1 FOR UPDATE;