| From: | Germán Hüttemann Arza <ghuttemann(at)cnc(dot)una(dot)py> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Auditing a database |
| Date: | 2007-04-19 12:39:54 |
| Message-ID: | 200704190839.54825.ghuttemann@cnc.una.py |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi,
I am developing a web application for auditing tables from a postgresql
database.
My question is: when an update occurrs in the base table, should I insert in
the auditing table the new record or the old one?
I was first inserting the new one but a job partner, who are testing the
application suggested that probably would be better to insert the old record
because it is simpler to follow the trace of updates.
What you suggest?
Regards,
--
Germán Hüttemann Arza
CNC - Centro Nacional de Computación
UNA - Universidad Nacional de Asunción
Campus Universitario, San Lorenzo - Paraguay
http://www.cnc.una.py - Tel.: 595 21 585550
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Germán Hüttemann Arza | 2007-04-19 13:15:27 | Auditing a database |
| Previous Message | Kenneth Downs | 2007-04-19 12:13:09 | Re: Postgres data/form entry tool |