1- How can I lock a single record so that other users can only read it. ??
You cannot do that in PostgreSQL.
How about SELECT ... FOR UPDATE?
-- Bill Moran Potential Technologies http://www.potentialtech.com
---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]