R: Help lock record - Mailing list pgsql-jdbc

From bitrunner
Subject R: Help lock record
Date
Msg-id 4473EB35.3080706@katamail.com
Whole thread Raw
Responses Re: R: Help lock record  (Dave Cramer <pg@fastcrypt.com>)
List pgsql-jdbc
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/


sorry but I dont have to understand.
How I can understand that there is an other user who lock the record?

Thanks.

pgsql-jdbc by date:

Previous
From: Kris Jurka
Date:
Subject: Re: New jdbc builds soon?
Next
From: Dave Cramer
Date:
Subject: Re: R: Help lock record