Thread: locking mechanism

hi,

1)If the same PROCLOCK has some already-granted locks and
   be waiting for more, how do we know?
 I currently use the holding array of PROCLOCK to figure out what lockmodes 
a transaction(process) has been granted on LOCK,and if holdings sum comes to 
0 that means this PROCLOCK is waiting for its associate LOCK. But how if the 
PROCLOCK has already been granted a lock and is waiting for another lock on 
the same object( LOCK), how do figure that out?



2)Is tuple level locks the same as row level locks?

Thanks!!

Jenny

_________________________________________________________________
Add photos to your e-mail with MSN 8. Get 2 months FREE*.  
http://join.msn.com/?page=features/featuredemail

"Jenny -" <nat_lazy@hotmail.com> writes:
> 1)If the same PROCLOCK has some already-granted locks and
>     be waiting for more, how do we know?

You look at the PROC object to see whether it is waiting, and if
so for what.
        regards, tom lane