Thread: How to detect values changed in field of foreign table?
<div dir="ltr"><span style="color:rgb(0,0,0);font-family:Verdana,Geneva,Helvetica,Arial,sans-serif;font-size:16.799999237060547px">Ihave an oracleforeign table that holds arbitrary tasks, when a task gets updated the "time_update" field will change. I want to detectwhen the field changes so I can insert the values in a local table for completed tasks. Can postgresql detect changesin a foreign table so a trigger can be invoked? I am new to postgrwsql so any examples or education on what stepsto take to complete tjos would be greatly appreciated!</span><br /></div>
On 01/26/2014 04:20 PM, Bob Spero wrote: > 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! Well there is a patch in the current CommitFest to add trigger support to Foreign Tables. Assuming it gets committed it will not be available until 9.4. Not sure how else you could accomplish what you want. More information would be useful for those folks that might have clue. So: What versions of Postgres, Oracle? What fdw are using to make the connection? -- Adrian Klaver adrian.klaver@gmail.com