obtaining row locking information
Tatsuo Ishii <t-ishii@sra.co.jp>
From: Tatsuo Ishii <t-ishii@sra.co.jp>
To: pgsql-hackers@postgresql.org
Date: 2005-08-07T12:46:08Z
Lists: pgsql-hackers
Attachments
- (unnamed) (text/plain)
Hi,
With a help from Bruce, I wrote a small function which returns row
locking information(see attached file if you are interested). Here is
a sample result:
test=# select * from pgrowlocks('t1');
locked_row | lock_type | locker | multi
------------+-----------+--------+-------
(0,1) | Shared | 1 | t
(0,3) | Exclusive | 575 | f
(2 rows)
I think it will be more usefull if actual xids are shown in the case
"locker" is a multixid. It seems GetMultiXactIdMembers() does the
job. Unfortunately that is a static funtcion, however. Is there any
chance GetMultiXactIdMembers() becomes public funtion?
--
Tatsuo Ishii