table-level and row-level locks. - Mailing list pgsql-hackers

From Jenny -
Subject table-level and row-level locks.
Date
Msg-id BAY1-F137scL9NtDEJm000038f1@hotmail.com
Whole thread Raw
Responses Re: table-level and row-level locks.  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
<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 <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><brclear="all" /><hr />MSN 8 with <a
href="http://g.msn.com/8HMRENUS/2740??PS=">e-mailvirus protection service: </a> 2 months FREE* 

pgsql-hackers by date:

Previous
From: ivan
Date:
Subject: Re: sugsestions
Next
From: Kurt Roeckx
Date:
Subject: Re: Possible psql bug