Home > mailing lists

a SELECT FOR UPDATE question - Mailing list pgsql-general

From	Tim Vadnais
Subject	a SELECT FOR UPDATE question
Date	February 8, 2005 02:09:15
Msg-id	B1BD543E7C06D51183B500A0C9AC2DB63E9F59@ntserver.asterion.com Whole thread Raw
Responses	Re: a SELECT FOR UPDATE question
List	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

From: Christopher Petrilli
Date: 08 February 2005, 02:08:53
Subject: Re: Use of indexes with table inheritance

From: Devrim GUNDUZ
Date: 08 February 2005, 02:38:13
Subject: [SECURITY] New sets of PostgreSQL RPMS are available for download