After you pointed me in the right direction, I was able to create a trigger procedure which can be called from triggers on various tables and will log the operation (including the affected table's oid and name). The procedure is listed below. Thanks for the help!
Tim
create or replace function add_log_entry() returns TRIGGER as '
BEGIN
insert into audit_log(table_oid, table_name, id, operation) values (TG_RELID, TG_RELNAME, NEW.id, TG_OP);
return NEW;
END;
' language 'plpgsql';
On Apr 27, 2004, at 8:18 AM, Richard Huxton wrote:
On Tuesday 27 April 2004 13:40, Timothy Perrigo wrote:Thanks for the reply. Do you know if triggers defined on a base table fire for operations on inherited tables? (I.e., if I have an after insert trigger on table "base", and a table "derived" that inherits from base, will inserts into derived cause the trigger on base to fire?)
Hmm - don't know this I'm afraid.
If so (this is the behavior I would like), is there a way to get the tableoid of the table which caused the trigger to fire?
Here I can help. Check the plpgsql section of the manuals, and there you'll
find a list of special variables available to trigger functions. These
include table and trigger name.
-- Richard Huxton Archonet Ltd
---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
