Skip site navigation (1) Skip section navigation (2)

How to find out that a record has been updated

From: "P(dot)V(dot) Subramanian" <pvsmian(at)hotmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: How to find out that a record has been updated
Date: 2001-10-05 18:52:25
Message-ID: F1872rZBtFk3NNTp0m6000055eb@hotmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
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


Responses

pgsql-novice by date

Next:From: P.V. SubramanianDate: 2001-10-05 18:56:10
Subject: The mystery of concurrent access
Previous:From: Jason EarlDate: 2001-10-05 18:08:12
Subject: Re: enum problem

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group