Re: Theoretical Basis for SELECT FOR UPDATE


"Tony Andrews" <andrewst@xxxxxxxxxx> wrote in message
news:1128080541.493388.182640@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> Marshall Spight wrote:

> I would say that SELECT FOR UPDATE is a valid facility in a DBMS that
> supports multi-statement transactions, even when cursors are not being
> used. It provides a means of locking data that was selected earlier in
> the transaction so that subsequent operations can use the selected data
> without risking violation of ACID properties (e.g. because another user
> deleted that row).

Locking is not part of the logical model. It has no place in a SELECT
statement.



.