> Would looking into currently held locks help ? You might get some false > positive because the transaction may have acquired a lock, but did not do > any modification. But if you can live with that, it might be worth > considering.
The locks disappear after corresponding sessions ends or the transaction ends so I don't think I can use them for my particular purpose. -- Tatsuo Ishii SRA OSS, Inc. Japan English: http://www.sraoss.co.jp/index_en.php Japanese: http://www.sraoss.co.jp -- Sent via pgsql-hackers mailing list (firstname.lastname@example.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers