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