Thread: How to find out that a record has been updated
Hi all I have an application that reads the contents of a few tables every 2 hours. If no new records have been added, and if no updates to existing records have been made in the last 2 hours, the app does nothing. If some records have been updated or added, the app does some work, and marks the record as processed. Currently anyone updating a record is expected to mark it manually as needing processing. Otherwise the application doesn't know. Is there a better, more user friendly way, for the app to automatically find out which records have been updated. Maybe a column that has a time field that Postgres can update to "now" each time an update is made? Thanks PVS _________________________________________________________________ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
"P.V. Subramanian" <pvsmian@hotmail.com> writes: > If some records have been updated or added, the app does some work, and > marks the record as processed. > Currently anyone updating a record is expected to mark it manually as > needing processing. Otherwise the application doesn't know. > Is there a better, more user friendly way, for the app to automatically find > out which records have been updated. You don't need to change the table definition; just add an ON UPDATE trigger that forces the marking column to be updated. regards, tom lane