locking mechanism - Mailing list pgsql-hackers

From Jenny -
Subject locking mechanism
Date
Msg-id BAY1-F22BQhExkiyPoH000005e1@hotmail.com
Whole thread Raw
List 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 

 



MSN 8 helps ELIMINATE E-MAIL VIRUSES. Get 2 months FREE*.

pgsql-hackers by date:

Previous
From: Philip Yarra
Date:
Subject: Re: Possible psql bug
Next
From: Rod Taylor
Date:
Subject: Re: static dumper idea