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


Wed, 23 Jul 2003 14:02:25 -0700
"Jenny -" <nat_lazy@hotmail.com>
locking mechanism
"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

Wed, 23 Jul 2003 22:10:04 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: locking mechanism 