From: | Michael Monnerie <michael(dot)monnerie(at)is(dot)it-management(dot)at> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | fail-safe sql update triggers |
Date: | 2010-09-03 13:03:19 |
Message-ID: | vmime.4c80f217.42d2.c43fd4a13aa09607@zarafa14.zmi.at |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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 not contain 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/
From | Date | Subject | |
---|---|---|---|
Next Message | Kevin Grittner | 2010-09-03 16:23:23 | Re: fail-safe sql update triggers |
Previous Message | Ireneusz Pluta | 2010-09-03 08:42:54 | Re: Autovacuum and invalid page header |