On Wed, 18 Feb 2004, Christopher Kings-Lynne wrote:
> >>> 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.
I just tested it (within transactions) and it appeared that I could still
view the rows selected for update.
