Re: How to know a table has been modified? - Mailing list pgsql-hackers

From Tatsuo Ishii
Subject Re: How to know a table has been modified?
Date
Msg-id 20120228.074904.2268657311407058612.t-ishii@sraoss.co.jp
Whole thread Raw
In response to Re: How to know a table has been modified?  (Pavan Deolasee <pavan.deolasee@gmail.com>)
List pgsql-hackers
> 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


pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Avoid FK validations for no-rewrite ALTER TABLE ALTER TYPE
Next
From: Christopher Browne
Date:
Subject: Re: leakproof