Re: How to know a table has been modified?

From: Tatsuo Ishii <ishii(at)postgresql(dot)org>
To: pavan(dot)deolasee(at)gmail(dot)com
Cc: lennin(dot)caro(at)yahoo(dot)com, Kevin(dot)Grittner(at)wicourts(dot)gov, pgsql-hackers(at)postgresql(dot)org
Subject: Re: How to know a table has been modified?
Date: 2012-02-27 22:49:04
Message-ID: 20120228.074904.2268657311407058612.t-ishii@sraoss.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Christopher Browne 2012-02-27 22:49:18 Re: leakproof
Previous Message Alvaro Herrera 2012-02-27 22:21:04 Re: Avoid FK validations for no-rewrite ALTER TABLE ALTER TYPE