a SELECT FOR UPDATE question

From: Tim Vadnais <tvadnais(at)bwks(dot)com>
To: "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org>
Subject: a SELECT FOR UPDATE question
Date: 2005-02-07 23:08:12
Message-ID: B1BD543E7C06D51183B500A0C9AC2DB63E9F59@ntserver.asterion.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

If I select a row for update, is there anyway that someone can query to see
if that row has been 'selected for update' and by whom?

Then I'd like to know if the session that 'SELECT(ed) FOR UPDATE' dies, will
the server release the locked row?

Thank you,

tvadnais

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Christopher Petrilli 2005-02-07 23:08:40 Re: Use of indexes with table inheritance
Previous Message Alvaro Herrera 2005-02-07 22:34:52 Re: Use of indexes with table inheritance