Thread: table-level and row-level locks.

<div style="background-color:"><div><div><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
ofproclock , I've noticed that by doing this only <dl><dt>AccessShareLock gets acquired which is a table level lock.
<dt>Howdo I acquire rowlevelock and what fields of Lock or Proclock datastructures indicate
it.<dt>Thanks<dt>Jenny</dl></div></div></div></div></div></div><brclear="all" /><hr />MSN 8 helps <a
href="http://g.msn.com/8HMLENUS/2743??PS=">ELIMINATEE-MAIL VIRUSES. </a> Get 2 months FREE*.