Thread: Exclusive Row access???

Is there a way in PostgreSQL to have a client lock a row in a table for
exclusive access?
I need to be able to lock individual rows in a table for SELECT and UPDATE
in the one client and deny all other clients from accessing those rows at
all while the lock is being held. They do need to be able to access other
rows that are not locked.

Thank you,

Lance Ellinghaus

Lance Ellinghaus wrote:

> Is there a way in PostgreSQL to have a client lock a row in a table for
> exclusive access?


Might want to start with section 9.6.2 of the PostgreSQL documentation,
"Row-Level Locks".  You may want SELECT FOR UPDATE, too.

-Fran