From: | Timothy Perrigo <tperrigo(at)wernervas(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | questions on rules |
Date: | 2004-04-26 19:12:14 |
Message-ID: | A0BC8174-97B5-11D8-B674-000A95C4F0A2@wernervas.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I'm trying to set up some basic rules to log inserts, updates, and
deletes to tables in an inheritance hierarchy (by inserting records
into a log table), and I've got a couple of questions.
(1) Is it possible to create a rule on a base table and have it
operate for all derived tables? I'd like to just create 3 rules
(insert/update/delete) on the base table and have them apply to all
inherited tables. Can this be done?
(2) I've got a very simple update rule-- create rule log_updates as on
update to foo do insert into audit_log(table_oid, id, log_what) values
(foo.tableoid, NEW.foo_id, 'U'); I had hoped that this would create a
single entry in my audit_log table for each row updated. However, it
seems to fire for each record in the "foo" table, even if the update
affected only one row! What am I doing wrong?
Any help would be very much appreciated. Thanks!
Tim Perrigo
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2004-04-26 19:46:45 | Re: 7.3.4 on Linux: UPDATE .. foo=foo+1 degrades massivly |
Previous Message | Philipp Buehler | 2004-04-26 19:04:28 | Re: 7.3.4 on Linux: UPDATE .. foo=foo+1 degrades massivly |