Re: Locking question?

Thank you Alvaro :)

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

On 1/30/07, Alvaro Herrera <alvherre(at)commandprompt(dot)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.
>