Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id D28F4475DD0 for ; Thu, 19 Sep 2002 23:00:11 -0400 (EDT) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by postgresql.org (Postfix) with ESMTP id 8DF0E475BD7 for ; Thu, 19 Sep 2002 23:00:10 -0400 (EDT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.5/8.12.5) with ESMTP id g8K2xc5D012107; Thu, 19 Sep 2002 22:59:38 -0400 (EDT) To: "alexandre :: aldeia digital" Cc: pgsql-sql@postgresql.org Subject: Re: Query Freeze In-reply-to: <3303.200.225.214.1.1032481889.squirrel@webmail.aldeiadigital.com.br> References: <3303.200.225.214.1.1032481889.squirrel@webmail.aldeiadigital.com.br> Comments: In-reply-to "alexandre :: aldeia digital" message dated "Thu, 19 Sep 2002 21:31:29 -0300" Date: Thu, 19 Sep 2002 22:59:38 -0400 Message-ID: <12106.1032490778@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200209/235 X-Sequence-Number: 9512 "alexandre :: aldeia digital" writes: > I have 3 applications in windows and they > starts 3 postgres backends. > The 1st app. call the 2nd and this call the 3rd. > In the same place of the 3rd backend, the query freeze. > If I kill the second backend(or app.), the query is released... I think your second backend is holding a lock that the third one needs. regards, tom lane