Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group