Re: acquiring row and page level locks

On Thu, Aug 28, 2003 at 20:08:33 -0700,
  Jenny - <nat_lazy@hotmail.com> wrote:
> hi ,
> coudl some one tell me how to acquire row-level and page level locks in
> postgresql.
> iam aware that table level locks can be acquired by the command:
> "lock table *tablename* in *locktype* mode;

select for update will get you row level write locks. It won't block
normal selects.