| From: | Dave Page <dpage(at)postgresql(dot)org> |
|---|---|
| To: | Germán Hüttemann Arza <ghuttemann(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Auditing a database |
| Date: | 2007-04-19 13:30:02 |
| Message-ID: | 46276EDA.4030503@postgresql.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Germán Hüttemann Arza wrote:
> 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?
Both?
Regards, Dave.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bill Moran | 2007-04-19 13:33:14 | Re: How often do I need to reindex tables? |
| Previous Message | Peter Neu | 2007-04-19 13:28:18 | Need help with db script, and daily routines |