table-level and row-level locks.
Started by Jenny -over 22 years ago1 messages
<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>
<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></DIV></div><br clear=all><hr>Help STOP SPAM with <a href="http://g.msn.com/8HMRENUS/2731??PS=">the new MSN 8 </a> and get 2 months FREE*</html>