Re: Tracking changes to a db table

[kyle]

This could be done entirely in the database with a trigger. I haven't actually used triggers before, but I think you can:

1. Create a table to hold the auditing data you want.
2. Create a trigger for UPDATE and DELETE. It will write into the auditing table.
3. Your display would then read out of the auditing table.

Here's PostgreSQL 7.4 Trigger documentation (I don't know what version you're using).