Re: Data in table changed?

On 2004.03.02 08:04 Thomas Holmgren wrote:

I need an efficient way of determining if data in
> a
> table has been changed (either updated, deleted or inserted). Can this
> be achieved without scanning the tables using expensive SQL? (my
> tables
> are _big_!) Is there some way to get a "time for last update" for a
> specific table? Or something similar I can use?

You could always make table of 'last changed' timestamps with
columns of tablename and timestamp. Then a function which takes
the name of the table and updates the last_changed table with
a timestamp is called from a trigger for insert, update, and
delete of each table. The CREATE TRIGGER would pass the name
of the table to the function.

Karl <kop(at)meme(dot)com>
Free Software: "You don't pay back, you pay forward."
-- Robert A. Heinlein