Exclusive Row access???
Lance Ellinghaus <lellinghaus@yahoo.com>
From: "Lance Ellinghaus" <lellinghaus@yahoo.com>
To: <pgsql-general@postgresql.org>
Date: 2002-03-12T17:12:29Z
Lists: pgsql-hackers, pgsql-general
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