Detecting when field value changes in Foreign Table?

Поиск
Список
Период
Сортировка
От bobspero
Тема Detecting when field value changes in Foreign Table?
Дата
Msg-id 1390781846059-5788896.post@n5.nabble.com
обсуждение исходный текст
Список pgsql-sql
I have an oracle foreign table that holds arbitrary tasks, when a task gets updated the "time_update" field will
change.I want to detect when the field changes so I can insert the values in a local table for completed tasks. Can
postgresqldetect changes in a foreign table so a trigger can be invoked? I am new to postgrwsql so any examples or
educationon what steps to take to complete tjos would be greatly appreciated! <br /><hr align="left" width="300" />
Viewthis message in context: <a
href="http://postgresql.1045698.n5.nabble.com/Detecting-when-field-value-changes-in-Foreign-Table-tp5788896.html">Detecting
whenfield value changes in Foreign Table?</a><br /> Sent from the <a
href="http://postgresql.1045698.n5.nabble.com/PostgreSQL-sql-f2142323.html">PostgreSQL- sql mailing list archive</a> at
Nabble.com.<br/> 

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

Предыдущее
От: Emi Lu
Дата:
Сообщение: Re: find all views depend on a schema/table
Следующее
От: Bob Spero
Дата:
Сообщение: How to detect values changed in field of foreign table?