Re: acquiring row and page level locks

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Jenny - <nat_lazy(at)hotmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: acquiring row and page level locks
Date: 2003-08-29 03:20:22
Message-ID: 20030829032022.GC5204@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, Aug 28, 2003 at 20:08:33 -0700,
Jenny - <nat_lazy(at)hotmail(dot)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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Joe Conway 2003-08-29 03:40:43 Re: Arrays and Indices / Foreign Keys
Previous Message Ron Johnson 2003-08-29 03:20:10 Re: Replication Ideas