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?
No, because users cannot read the locked row in that case.
Chris
---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
