... - Mailing list pgsql-hackers

From Jenny -
Subject ...
Date
Msg-id BAY1-F94SKNZ6UTKIUA00016b39@hotmail.com
Whole thread Raw
Responses Re:
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


Add photos to your messages with MSN 8. Get 2 months FREE*.

pgsql-hackers by date:

Previous
From: "Paulo Scardine"
Date:
Subject: Re: SELECT FOR UPDATE NOWAIT
Next
From: Tom Lane
Date:
Subject: Re: SELECT FOR UPDATE NOWAIT