Re: Audit trail ? - Mailing list pgsql-general

From Zlatko Matic
Subject Re: Audit trail ?
Date
Msg-id 000f01c564f8$1f26f140$a6301dc3@zlatkovyfkpgz6
Whole thread Raw
In response to Question: migrate  (Hrishikesh Deshmukh <hdeshmuk@gmail.com>)
List pgsql-general
Hello, Mike!
Your solution for audit trail is wonderfull! Easy and elegant !
It helped me a lot and I successfully implemented it, with small
modifications.

Thanky you very much!


----- Original Message -----
From: "Mike Rylander" <mrylander@gmail.com>
To: "Zlatko Matic" <zlatko.matic1@sb.t-com.hr>
Cc: "Postgresql-General" <pgsql-general@postgresql.org>
Sent: Sunday, May 29, 2005 6:21 PM
Subject: Re: [GENERAL] Audit trail ?


On 5/29/05, Zlatko Matic <zlatko.matic1@sb.t-com.hr> wrote:
> Hello.
>
> I must have audit trail of all insert/update/delete on several table. I
> have
> several questions regarding that:
>
> 1. Is it better to have one audit trail table that collects
> insert/update/delete of all audited tables, or it is better to have
> separate
> audit trail table for every audited table ?
> 2. To use triggers or rules ? Example for both ?
> 3. Could someone give me an example of a successfull audit trail solution
> ?
>
> I'm running on lack of time, so any help would be precious...

We use the "audit table per real table" approach.  The SQL script to
create the audit trail functions and triggers is attached.  There are
three example audit trail table creation calls right before the
COMMIT.

Hope that helps!

--
Mike Rylander
mrylander@gmail.com
GPLS -- PINES Development
Database Developer
http://open-ils.org


pgsql-general by date:

Previous
From: "Ets ROLLAND"
Date:
Subject: Carriage return in text fields
Next
From: Philip Rhoades
Date:
Subject: Subselects - recursion problem