>select for update will get you row level write locks. It won't block
>normal selects.
there are no row level read locks in postgresql right?
thanks
jenny
>From: Bruno Wolff III <bruno@wolff.to>
>To: Jenny - <nat_lazy@hotmail.com>
>CC: pgsql-general@postgresql.org
>Subject: Re: [GENERAL] acquiring row and page level locks
>Date: Thu, 28 Aug 2003 22:20:22 -0500
>
>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.
_________________________________________________________________
Get MSN 8 and help protect your children with advanced parental controls.
http://join.msn.com/?page=features/parental