<html><div style='background-color:'><DIV>
<DIV>
<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>How do I acquire rowlevelock and what fields of Lock or Proclock datastructures indicate it.
<DT>Thanks
<DT>Jenny</DT></DIV></DIV></DIV></div><br clear=all><hr>Add photos to your messages with <a href="http://g.msn.com/8HMRENUS/2749??PS=">MSN 8. </a> Get 2 months FREE*.</html>