Re: Auditing a database - Mailing list pgsql-general

From Richard Huxton
Subject Re: Auditing a database
Date
Msg-id 46276DCC.6070408@archonet.com
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?

Old - you already have the new version in the main table.

Before you spend too long working on this though, I'd search for "audit"
on www.pgfoundry.org


--
   Richard Huxton
   Archonet Ltd

pgsql-general by date:

Previous
From: Germán Hüttemann Arza
Date:
Subject: Auditing a database
Next
From: Kenneth Downs
Date:
Subject: Re: Auditing a database