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 <[EMAIL PROTECTED]>
Free Software: "You don't pay back, you pay forward."
-- Robert A. Heinlein---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
