table-level and row-level locks.

From: "Jenny -" <nat_lazy(at)hotmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: table-level and row-level locks.
Date: 2003-07-23 01:00:58
Message-ID: BAY1-F30SwidYoN3d4O00022ea7@hotmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

<html><div style='background-color:'><DIV>
<DIV>
<DIV>
<DIV>
<DIV>
<DIV>
<DIV>Iam trying to acquire rowlevel locks in postgresql. I try doing this: </DIV>
<DIV>&nbsp;'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></DIV></DIV></DIV></div><br clear=all><hr>MSN 8 helps <a href="http://g.msn.com/8HMVENUS/2752??PS=">ELIMINATE E-MAIL VIRUSES.</a> Get 2 months FREE*.</html>

Attachment Content-Type Size
unknown_filename text/html 703 bytes

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Christopher Kings-Lynne 2003-07-23 01:17:28 Re: tsearch2 for 7.3.X
Previous Message Hauke Joachim Zuehl 2003-07-23 00:09:10 pg_conn not declared in libpq-fe.h?