





Iam trying to acquire rowlevel locks in postgresql. I try doing this: 
 'select * from students where name='Larry' for update;
But by looking at the holding array of proclock , I've noticed that by doing this only 
AccessShareLock gets acquired which is a table level lock. 
How do I acquire rowlevelock and what fields of Lock or Proclock datastructures indicate it.
Thanks
JennyMSN 8 helps ELIMINATE E-MAIL VIRUSES. Get 2 months FREE*.

Tue, 22 Jul 2003 18:00:58 -0700
"Jenny -" <nat_lazy@hotmail.com>
table-level and row-level locks.

Once more unto the breach -

    Could you please abstain from sending HTML email to the list ? 
    Many thanks !

-- 
Pip-pip
Sailesh
http://www.cs.berkeley.edu/~sailesh



22 Jul 2003 22:11:06 -0700
Sailesh Krishnamurthy <sailesh@cs.berkeley.edu>
Re: table-level and row-level locks.