<html><div style='background-color:'><DIV>Iam trying to acquire rowlevel locks in postgresql. I try doing this: </DIV>
<DIV> 'select * from students where name='Larry' for update;</DIV>
<DIV>But by looking at the holding array of proclock , I've noticed that by doing this only
<DT>AccessShareLock gets acquired which is a table level lock. </DT>
<DT>How do I acquire rowlevelock and what fields of Lock or Proclock datastructures indicate it.</DT>
<DT>Thanks</DT>
<DT>Jenny</DT></DIV></div><br clear=all><hr>MSN 8 with <a href="http://g.msn.com/8HMRENUS/2740??PS=">e-mail virus protection service: </a> 2 months FREE*</html>