Received: from malur.postgresql.org ([217.196.149.56])
 by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from
 <pgsql-sql-owner+M37624=pgsql+2Dsql=arkaria.postgresql.org@postgresql.org>)
 id 1W7ZtP-00005j-MY
 for pgsql-sql@arkaria.postgresql.org; Mon, 27 Jan 2014 00:17:35 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
 by malur.postgresql.org with smtp (Exim 4.80) (envelope-from
 <pgsql-sql-owner+M37624=pgsql+2Dsql=arkaria.postgresql.org@postgresql.org>)
 id 1W7ZtO-0007NJ-B7
 for pgsql-sql@arkaria.postgresql.org; Mon, 27 Jan 2014 00:17:34 +0000
Received: from makus.postgresql.org ([2001:4800:7903:4::125])
 by malur.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <bobspero@gmail.com>) id 1W7ZtN-0007NC-86
 for pgsql-sql@postgresql.org; Mon, 27 Jan 2014 00:17:33 +0000
Received: from sam.nabble.com ([216.139.236.26])
 by makus.postgresql.org with esmtp (Exim 4.80)
 (envelope-from <bobspero@gmail.com>) id 1W7ZtG-0003pC-JT
 for pgsql-sql@postgresql.org; Mon, 27 Jan 2014 00:17:32 +0000
Received: from [192.168.236.26] (helo=sam.nabble.com)
 by sam.nabble.com with esmtp (Exim 4.72)
 (envelope-from <bobspero@gmail.com>) id 1W7ZtG-0000es-2X
 for pgsql-sql@postgresql.org; Sun, 26 Jan 2014 16:17:26 -0800
Date: Sun, 26 Jan 2014 16:17:26 -0800 (PST)
From: bobspero <bobspero@gmail.com>
To: pgsql-sql@postgresql.org
Message-ID: <1390781846059-5788896.post@n5.nabble.com>
Subject: Detecting when field value changes in Foreign Table?
MIME-Version: 1.0
Content-Type: multipart/alternative;
 boundary="----=_Part_6600_24787900.1390781846073"
X-Pg-Spam-Score: 3.5 (+++)
List-Archive: <http://archives.postgresql.org/pgsql-sql>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-sql.postgresql.org>
List-Owner: <mailto:pgsql-sql-owner@postgresql.org>
List-Post: <mailto:pgsql-sql@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-sql>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-sql>
X-Mailing-List: pgsql-sql
Precedence: bulk
Sender: pgsql-sql-owner@postgresql.org

------=_Part_6600_24787900.1390781846073
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

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!  



--
View this message in context: http://postgresql.1045698.n5.nabble.com/Detecting-when-field-value-changes-in-Foreign-Table-tp5788896.html
Sent from the PostgreSQL - sql mailing list archive at Nabble.com.
------=_Part_6600_24787900.1390781846073
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit

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!  

	
	
	
<br/><hr align="left" width="300" />
View this message in context: <a href="http://postgresql.1045698.n5.nabble.com/Detecting-when-field-value-changes-in-Foreign-Table-tp5788896.html">Detecting when field 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/>
------=_Part_6600_24787900.1390781846073--