I use a modified form of option 3 with an ON UPDATE RULE the update rule
copies the row to an inherited table...
CREATE TABLE dm_user (
id SERIAL NOT NULL PRIMARY KEY,
lu_user_type INTEGER NOT NULL REFERENCES lu_user_type(id),
dm_user_address INTEGER NOT NULL DEFAULT 0,
Hello list,
I need to define an audit system that would be easyli include or exclude
certain tables, the process is a purchase order where many users changes
the info in diferent ways, the requerimient is to log the stamp and user
of the change on a table and additionaly log a snapshot of the th
