On 23-May-06, at 1:37 PM, bitrunner wrote:
> For lock the record I use:
> select * from orders where id = 17 for update
>
> in this way lock the record with id = 17.
> If an other user demands the same record as I can understand that
> it is lock?
yes as long as autocommit is false this is true. In other words as
long as you do this inside a transaction/
>
> Thanks a lot.
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>