this is in plain text (row level locks) - Mailing list pgsql-hackers

From Jenny -
Subject this is in plain text (row level locks)
Date
Msg-id BAY1-F58p7mvjkO22Zh000001d1@hotmail.com
Whole thread Raw
Responses Re: this is in plain text (row level locks)  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Iam trying to acquire rowlevel locks in postgresql. I try doing this:
'select * from students where name='Larry' for update;
But by looking at the holding array of proclock , I've noticed that by doing 
this only
AccessShareLock gets acquired which is a table level lock.
How do I acquire rowlevelock and what fields of Lock or Proclock 
datastructures indicate it.
Thanks
Jenny

_________________________________________________________________
Protect your PC - get McAfee.com VirusScan Online  
http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963



pgsql-hackers by date:

Previous
From: Larry Rosenman
Date:
Subject: Re: Feature request -- Log Database Name
Next
From: Mike Mascari
Date:
Subject: Re: how do i turn off the html tags??