From: | "Jenny -" <nat_lazy(at)hotmail(dot)com> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | locking mechanism |
Date: | 2003-07-23 21:02:25 |
Message-ID: | BAY1-F1047j1HaKtKuf00000400@hotmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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
From | Date | Subject | |
---|---|---|---|
Next Message | ivan | 2003-07-23 22:04:14 | Re: did you read my mails ? |
Previous Message | Josh Berkus | 2003-07-23 20:32:56 | Re: Feature request -- Log Database Name |