agora inbox for pgsql-sql@postgresql.org  

help / color / mirror / Atom feed

From: Adrian Klaver <adrian.klaver@gmail.com>
To: Bob Spero <bobspero@gmail.com>
To: pgsql-sql@postgresql.org
Subject: Re: How to detect values changed in field of foreign table?
Date: Thu, 30 Jan 2014 07:41:41 -0800
Message-ID: <52EA72B5.5040304@gmail.com> (raw)
In-Reply-To: <CACgt7QVjRTja-9pY1xH47sK8D2VagLGAY9gA6V-ckqBW0ao4sg@mail.gmail.com>
References: <CACgt7QVjRTja-9pY1xH47sK8D2VagLGAY9gA6V-ckqBW0ao4sg@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-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

view thread (2+ messages)

Message-ID: <52EA72B5.5040304@gmail.com>
Permalink:  ../52EA72B5.5040304@gmail.com/
Also on:    postgresql.org/message-id/52EA72B5.5040304@gmail.com

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: adrian.klaver@gmail.com, bobspero@gmail.com
  Subject: Re: How to detect values changed in field of foreign table?
  In-Reply-To: <52EA72B5.5040304@gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox