

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
JennyHelp STOP SPAM with the new MSN 8  and get 2 months FREE*

Thu, 10 Jul 2003 11:40:25 -0700
"Jenny -" <nat_lazy@hotmail.com>
table-level and row-level locks.