Re: unlock Select for update

From: Neil Conway <neilc(at)samurai(dot)com>
To: jose antonio leo <jaleo8(at)storelandia(dot)com>
Cc: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: unlock Select for update
Date: 2003-03-10 18:04:54
Message-ID: 1047319494.353.26.camel@tokyo
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)samurai(dot)com> || PGP Key ID: DB3C29FC

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Hunter Hillegas 2003-03-10 18:25:48 Not Enough Connections
Previous Message Matthew Phillips 2003-03-10 17:47:33 mapping user name to group name