Re: update table with row locking

On Thu, Dec 23, 2004 at 11:56:26AM -0800, Mark wrote:

> Is it possible to lock row(s) when updating a table, so another call
> for update( from different session) will be rejected and to be on
> hold until lock get released ?

The UPDATE statement automatically acquires locks, but if you need
more control then you could use SELECT FOR UPDATE or LOCK.  For
more information see the "Concurrency Control" chapter in the
documentation.

What problem are you trying to solve?  Depending on what you're
doing, you might not need to use explicit locking.

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/