Postgres Pro
Downloads
Home   >   mailing lists

session hang for same row update - Mailing list pgsql-general

From AI Rumman
Subject session hang for same row update
Date
Msg-id CAGoODpdnxsSr6OtC78=SyHs+OGjb8dyZiqXOX=grFqdSK3TYUg@mail.gmail.com
Whole thread Raw
Responses Re: session hang for same row update
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: Streaming Replication Over SSL
Next
From: Adrian Klaver
Date:
Subject: Re: session hang for same row update