Thread: Detecting when field value changes in Foreign Table?

Detecting when field value changes in Foreign Table?

From
bobspero
Date:
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/>