Could anyone please tell me why the session 2 is hanging?
I am using Postgresql 9.1.

show deadlock_timeout ;
 deadlock_timeout
------------------
 1s
(1 row)


  select * from t2;
 i | nam
---+-----
 2 | t4
 1 | t3

Session 1:
BEGIN
update t2 set nam = 't3' where i=2;
UPDATE 1

Session 2:
BEGIN
update t2 set nam = 't3' where i=2;
hanged

Reply via email to