Re: Query Freeze

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "alexandre :: aldeia digital" <alepaes(at)aldeiadigital(dot)com(dot)br>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Query Freeze
Date: 2002-09-20 02:59:38
Message-ID: 12106.1032490778@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

"alexandre :: aldeia digital" <alepaes(at)aldeiadigital(dot)com(dot)br> 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

In response to

  • Query Freeze at 2002-09-20 00:31:29 from alexandre :: aldeia digital

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Ajit Aranha 2002-09-20 06:09:16 Null not equal to '' (empty)
Previous Message CN LIOU 2002-09-20 02:07:11 Two Permance Questions