Re: Auditing a database - Mailing list pgsql-general

From Dave Page
Subject Re: Auditing a database
Date
Msg-id 46276EDA.4030503@postgresql.org
Whole thread Raw
In response to Auditing a database  (Germán Hüttemann Arza <ghuttemann@gmail.com>)
List 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.

pgsql-general by date:

Previous
From: "Peter Neu"
Date:
Subject: Need help with db script, and daily routines
Next
From: Bill Moran
Date:
Subject: Re: How often do I need to reindex tables?