Re: Locking question? - Mailing list pgsql-general

From Shoaib Mir
Subject Re: Locking question?
Date
Msg-id bf54be870701291219l206cb980xd8d147bb90aa3fa6@mail.gmail.com
Whole thread Raw
In response to Re: Locking question?  (Alvaro Herrera <alvherre@commandprompt.com>)
List pgsql-general
Thank you Alvaro :)

-----------------
Shoaib Mir
EnterpriseDB (www.enterprisedb.com )

On 1/30/07, Alvaro Herrera <alvherre@commandprompt.com> wrote:
Shoaib Mir wrote:
> While debugging an application, I just wanted to confirm from the list here:
>
> Suppose I have a long running transaction which has a few updates and
> inserts running on some specific tables which means it has acquired
> Exclusive locks too during the transaction on specific table but if just
> before commit the client app crashes and the commit is never sent, will the
> Exclusive locks be automatically released?

Yes  (assuming the backend dies in the process, which may not happen if
the app dies silently and while not waiting for anything from the
server).

--
Alvaro Herrera                                 http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Limit on number of users in postgresql?
Next
From: Tom Lane
Date:
Subject: Re: dependency ?