Contents

• Audit(?) logging
• Why?
• A simple approach
• Why?
• Our actual requirement
• Our solution
• Our solution: tables
• INSERT trigger function
• UPDATE trigger function
• DELETE trigger function
• DELETE helper function
• Add triggers to table
• Some transactions
• Resulting person records
• Resulting person_hst records
• One last transaction
• Resulting person records
• Resulting person_hst records
• INSERT trigger redux
• Generating history triggers
• The End