View Single Post

   
  #2 (permalink)  
Old 04-10-2008, 06:04 AM
Tom Lane
 
Posts: n/a
Default Re: Blocking connection and timeout problem

=?iso-8859-1?Q?K=D6PFERL_Robert?= <robert.koepferl@sonorys.at> writes:
> Why is that? Why isn't client A's transaction detected as dead ?


It will be eventually, when the TCP connection times out. The standard
timeout is generally an hour or two :-(

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

Reply With Quote