Re: Auditing a database - Mailing list pgsql-general

From Andreas 'ads' Scherbaum
Subject Re: Auditing a database
Date
Msg-id 20070423112241.8e72c5e7.adsmail@wars-nicht.de
Whole thread Raw
In response to Re: Auditing a database  (Kenneth Downs <ken@secdat.com>)
List pgsql-general
Hello all,

On Thu, 19 Apr 2007 09:27:33 -0400
Kenneth Downs <ken@secdat.com> wrote:

> Ask the question: can I make sure I always have a complete trail?  If
> you insert the old row, you will always have the old values and the
> table itself holds the new values.

In tablelog (http://pgfoundry.org/projects/tablelog/) i decided to have both rows, the old and the new one. So i don't
needto lookup the current state in the original table and be able to fetch any data from one single audit table. 


> Germán Hüttemann Arza wrote:

Your quoting ... well, sucks ;-)


Kind regards

--
                Andreas 'ads' Scherbaum
Deutsche PostgreSQL Usergroup: http://www.pgug.de
DPWN: http://ads.wars-nicht.de/blog/categories/18-PWN

pgsql-general by date:

Previous
From: "Magnus Hagander"
Date:
Subject: Re: ERROR: Failed to build any 5-way joins
Next
From: Andrew Kroeger
Date:
Subject: Re: selective export for subsequent import (COPY)