Postgres Pro
Downloads
Home   >   mailing lists

Detecting when field value changes in Foreign Table? - Mailing list pgsql-sql

From bobspero
Subject Detecting when field value changes in Foreign Table?
Date
Msg-id 1390781846059-5788896.post@n5.nabble.com
Whole thread Raw
List pgsql-sql
Tree view 
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 by date:

Previous
From: Emi Lu
Date:
Subject: Re: find all views depend on a schema/table
Next
From: Bob Spero
Date:
Subject: How to detect values changed in field of foreign table?