"Jenny -" <[EMAIL PROTECTED]> writes:
> <html><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
> <DT>AccessShareLock gets acquired which is a table level lock. </DT>
Please do not use HTML mail on this list ...
Anyway, the answer to your question is that row locks are recorded on
disk (by marking the tuple as locked). We'd soon run out of memory
if we tried to record them in the shared lock table.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
