Re: How to know a table has been modified?

Поиск
Список
Период
Сортировка
От Kevin Grittner
Тема Re: How to know a table has been modified?
Дата
Msg-id 4F4A043E0200002500045BE6@gw.wicourts.gov
обсуждение исходный текст
Ответ на How to know a table has been modified?  (Tatsuo Ishii <ishii@postgresql.org>)
Ответы Re: How to know a table has been modified?  (Tatsuo Ishii <ishii@postgresql.org>)
Список 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


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: leakproof
Следующее
От: Heikki Linnakangas
Дата:
Сообщение: Re: COPY with hints, rebirth