I want to log all activity from a table to a old_table. Creating an ON INSERT trigger is simple, it just needs to
INSERT INTO old_filter SELECT NEW.*;
in a procedure that is called via the trigger. But what about updates? There is no simple
UPDATE old_filter SET NEW.* WHERE id=NEW.id;
so I would need to declare each column like
UPDATE old_filter SET field1=NEW.field1,f2=NEW.f2,.... where id=NEW.id;
But that is error prone, because when the "filter" table is changed to have a new column, the UPDATE statement would
notcontain it. Is there a fail-proof shortcut?
mit freundlichen Grüßen
Michael Monnerie, Ing. BSc
it-management Internet Services
http://proteger.at [gesprochen: Prot-e-schee]
Tel: 0660 / 415 65 31
// Wir haben im Moment zwei Häuser zu verkaufen:
// http://zmi.at/langegg/
// http://zmi.at/haus2009/