Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 3E21F476B55 for ; Fri, 20 Sep 2002 09:37:51 -0400 (EDT) Received: from spirit.aldeiadigital.com.br (iplus-fac-137.xdsl-fixo.ctbcnetsuper.com.br [200.225.213.137]) by postgresql.org (Postfix) with ESMTP id 0014D476B25 for ; Fri, 20 Sep 2002 09:37:48 -0400 (EDT) Received: from aldeiadigital.com.br (localhost.localdomain [127.0.0.1]) by spirit.aldeiadigital.com.br (8.11.6/8.11.4) with SMTP id g8KDd9R16521 for ; Fri, 20 Sep 2002 10:39:09 -0300 Received: from 200.225.214.1 (proxying for 192.168.1.204) (SquirrelMail authenticated user alepaes) by webmail.aldeiadigital.com.br with HTTP; Fri, 20 Sep 2002 10:39:09 -0300 (BRT) Message-ID: <1218.200.225.214.1.1032529149.squirrel@webmail.aldeiadigital.com.br> Date: Fri, 20 Sep 2002 10:39:09 -0300 (BRT) Subject: Re: Query Freeze From: "alexandre :: aldeia digital" To: In-Reply-To: <12106.1032490778@sss.pgh.pa.us> References: <3303.200.225.214.1.1032481889.squirrel@webmail.aldeiadigital.com.br> <12106.1032490778@sss.pgh.pa.us> X-Priority: 3 Importance: Normal X-MSMail-Priority: Normal X-Mailer: SquirrelMail (version 1.2.7) MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: by AMaViS-perl11-milter (http://amavis.org/) X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200209/240 X-Sequence-Number: 9517 > "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. I will search in the applications... Very thank´s. Alexandre