Detecting when field value changes in Foreign Table?

From: bobspero <bobspero(at)gmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Detecting when field value changes in Foreign Table?
Date: 2014-01-27 00:17:26
Message-ID: 1390781846059-5788896.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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
postgresql detect changes in a foreign table so a trigger can be invoked? I
am new to postgrwsql so any examples or education on what steps to take to
complete tjos would be greatly appreciated!

--
View this message in context: http://postgresql.1045698.n5.nabble.com/Detecting-when-field-value-changes-in-Foreign-Table-tp5788896.html
Sent from the PostgreSQL - sql mailing list archive at Nabble.com.

Browse pgsql-sql by date

  From Date Subject
Next Message Bob Spero 2014-01-27 00:20:25 How to detect values changed in field of foreign table?
Previous Message Emi Lu 2014-01-24 17:04:11 Re: find all views depend on a schema/table