Re: unlock Select for update - Mailing list pgsql-general

From Neil Conway
Subject Re: unlock Select for update
Date
Msg-id 1047319494.353.26.camel@tokyo
Whole thread Raw
In response to Re: unlock Select for update  ("jose antonio leo" <jaleo8@storelandia.com>)
Responses Re: unlock Select for update  ("jose antonio leo" <jaleo8@storelandia.com>)
List pgsql-general
On Mon, 2003-03-10 at 12:15, jose antonio leo wrote:
> Sorry, I explain more...
> I have got a aplication that it do maintenance of DB, One user are updating
> a row locked for a select for update and this user switch off your pc and he
> leaves the row locked.

When the client disconnects, any uncommitted transaction (if any) will
be aborted, so the lock will be released.

Cheers,

Neil

--
Neil Conway <neilc@samurai.com> || PGP Key ID: DB3C29FC




pgsql-general by date:

Previous
From: Matthew Phillips
Date:
Subject: mapping user name to group name
Next
From: Hunter Hillegas
Date:
Subject: Not Enough Connections