Re: acquiring row and page level locks - Mailing list pgsql-general

From Bruno Wolff III
Subject Re: acquiring row and page level locks
Date
Msg-id 20030829032022.GC5204@wolff.to
Whole thread Raw
In response to acquiring row and page level locks  ("Jenny -" <nat_lazy@hotmail.com>)
List pgsql-general
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.

pgsql-general by date:

Previous
From: "Jenny -"
Date:
Subject: acquiring row and page level locks
Next
From: Ron Johnson
Date:
Subject: Re: Replication Ideas