Horton
Menu

Re: Exclusive Row access???

Fran Fabrizio <ffabrizio@mmrd.com>

View thread
From: Fran Fabrizio <ffabrizio@mmrd.com>
To: Lance Ellinghaus <lellinghaus@yahoo.com>
Cc: pgsql-general@postgresql.org
Date: 2002-03-12T18:03:15Z
Lists: pgsql-hackers, pgsql-general 
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