Re: Audit trail

From: Jeff Fitzmyers <jeff(at)cloverpub(dot)com>
To:
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Audit trail
Date: 2003-03-13 04:18:47
Message-ID: E2B31091-550A-11D7-9482-000A959C6000@cloverpub.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> I am wondering if anyone has any good solutions for having postgres
> leave an audit trail.

I had 2 tables that needed a simple audit trail. It was very easy to
set up using php.

A few lines of code within transactions:
When a row is created, log it.
When any changes happen, log them, who did them and why.

I never felt I needed all the info for each row - just the changes.

Jeff

In response to

  • Audit trail at 2003-03-13 14:33:20 from James Gregory

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joe Conway 2003-03-13 04:40:37 Re: Audit trail
Previous Message Marc G. Fournier 2003-03-13 04:00:56 Re: removal from list