Request a Demo
Home   >   mailing lists

How to detect values changed in field of foreign table? - Mailing list pgsql-sql

From Bob Spero
Subject How to detect values changed in field of foreign table?
Date
Msg-id CACgt7QVjRTja-9pY1xH47sK8D2VagLGAY9gA6V-ckqBW0ao4sg@mail.gmail.com
Whole thread
Responses Re: How to detect values changed in field of foreign table?
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 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!

pgsql-sql by date:

Previous
From: bobspero
Date:
Subject: Detecting when field value changes in Foreign Table?
Next
From: Tim Landscheidt
Date:
Subject: Re: find all views depend on a schema/table