agora inbox for pgsql-sql@postgresql.org
help / color / mirror / Atom feedHow to detect values changed in field of foreign table?
2+ messages / 2 participants
[nested] [flat]
* How to detect values changed in field of foreign table?
@ 2014-01-27 00:20 Bob Spero <bobspero@gmail.com>
0 siblings, 1 reply; 2+ messages in thread
From: Bob Spero @ 2014-01-27 00:20 UTC (permalink / raw)
To: 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!
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: How to detect values changed in field of foreign table?
@ 2014-01-30 15:41 Adrian Klaver <adrian.klaver@gmail.com>
parent: Bob Spero <bobspero@gmail.com>
0 siblings, 0 replies; 2+ messages in thread
From: Adrian Klaver @ 2014-01-30 15:41 UTC (permalink / raw)
To: Bob Spero <bobspero@gmail.com>; pgsql-sql
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
--
Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-sql
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2014-01-30 15:41 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2014-01-27 00:20 How to detect values changed in field of foreign table? Bob Spero <bobspero@gmail.com>
2014-01-30 15:41 ` Adrian Klaver <adrian.klaver@gmail.com>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox