From: | Joachim Wieland <joe(at)mcknight(dot)de> |
---|---|
To: | John Sidney-Woollett <johnsw(at)wardbrook(dot)com> |
Cc: | Karen Hill <karen_hill22(at)yahoo(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: cyclical redundancy checksum algorithm(s)? |
Date: | 2006-09-28 08:30:15 |
Message-ID: | 20060928083015.GA2663@mcknight.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Thu, Sep 28, 2006 at 07:09:43AM +0100, John Sidney-Woollett wrote:
> Why not use an update trigger on the affected tables to record a
> lastupdated timestamp value when the record is changed.
> Surely this is simpler thanks computing some kind of row hash?
It depends on how you define "change". With the triggers you propose an
UPDATE table SET col = col;
is a change because there was a write operation. Any hash function's output
would be "no change" because the actual data did not change. An update might
entail an expensive update of some external data so you might want to make
sure that data really got modified.
--
Joachim Wieland joe(at)mcknight(dot)de
GPG key available
From | Date | Subject | |
---|---|---|---|
Next Message | John Sidney-Woollett | 2006-09-28 08:43:13 | Re: cyclical redundancy checksum algorithm(s)? |
Previous Message | A. Kretschmer | 2006-09-28 08:15:19 | Re: Definition of return types for own functions? |