Обсуждение: Compute hash of a table?

Hi All

I need to determine whether the content of a given table has changed from 
the previous time I've checked it. so, my initial idea is to calculate a 
hash value of the content of the whole table, may be with custom aggregate 
function or something.

My question is:

Is it possible to get the last time(stamp) when the content of a given table 
in pgsql has changed???

Thanks!
Pete

Hi, Peter,

Peter Manchev wrote:

> Is it possible to get the last time(stamp) when the content of a given
> table in pgsql has changed???

My solution would be to add a trigger to the table which updates a
timestamp in a second table on every insert/update/delete.


HTH,
Markus



-- 
Markus Schaber | Logical Tracking&Tracing International AG
Dipl. Inf.     | Software Development GIS

Fight against software patents in EU! www.ffii.org www.nosoftwarepatents.org