Re: unlock Select for update

Unfortunately In my aplication this non occur . When the client disconnects
the row keep blocked and then I have kill the process manually for unlocked
the row.

You know why it happends?


-----Mensaje original-----
De: Neil Conway [mailto:neilc@samurai.com]
Enviado el: lunes, 10 de marzo de 2003 19:05
Para: jose antonio leo
CC: Bruce Momjian; pgsql-general
Asunto: RE: [GENERAL] unlock Select for update


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