Re: Query Freeze - Mailing list pgsql-sql

From Tom Lane
Subject Re: Query Freeze
Date
Msg-id 12106.1032490778@sss.pgh.pa.us
Whole thread Raw
In response to Query Freeze  ("alexandre :: aldeia digital" <alepaes@aldeiadigital.com.br>)
Responses Re: Query Freeze  ("alexandre :: aldeia digital" <alepaes@aldeiadigital.com.br>)
List pgsql-sql
"alexandre :: aldeia digital" <alepaes@aldeiadigital.com.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


pgsql-sql by date:

Previous
From: Dima Tkach
Date:
Subject: Re: Effective usage without unique key -- suggestion
Next
From: "wit"
Date:
Subject: check source of trigger