Re: How to know a table has been modified?

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: <ishii(at)postgresql(dot)org>,<pgsql-hackers(at)postgresql(dot)org>
Subject: Re: How to know a table has been modified?
Date: 2012-02-26 16:06:54
Message-ID: 4F4A043E0200002500045BE6@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Tatsuo Ishii wrote:

> For TRIGGER, I cannot thinking of any way. Any idea will be
> welcome.

It would require creating "cooperating" triggers in the database and
having a listener, but you might consider the
triggered_change_notifications() trigger function included in 9.2.
It works at least as far back as 9.0; I haven't tried it any further
back.

-Kevin

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Heikki Linnakangas 2012-02-26 19:16:46 Re: COPY with hints, rebirth
Previous Message Peter Eisentraut 2012-02-26 15:39:09 Re: leakproof