| From: | Andreas 'ads' Scherbaum <adsmail(at)wars-nicht(dot)de> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Auditing a database |
| Date: | 2007-04-23 09:22:41 |
| Message-ID: | 20070423112241.8e72c5e7.adsmail@wars-nicht.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hello all,
On Thu, 19 Apr 2007 09:27:33 -0400
Kenneth Downs <ken(at)secdat(dot)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 need to 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Iain Adams | 2007-04-23 11:25:20 | Mass Update |
| Previous Message | shieldy | 2007-04-23 07:27:26 | The directory of the postgresql source |