Table audit system

From: josue <josue(at)lamundial(dot)hn>
To: PgSQL General List <pgsql-general(at)postgresql(dot)org>
Subject: Table audit system
Date: 2005-03-23 14:05:45
Message-ID: 424177B9.8000600@lamundial.hn
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello list,

I need to define an audit system that would be easyli include or exclude
certain tables, the process is a purchase order where many users changes
the info in diferent ways, the requerimient is to log the stamp and user
of the change on a table and additionaly log a snapshot of the the order
at the time it was change, that must include any child table too,
generally the order document includes the order header main table, the
order detail child table, the order costs child table and the order
comment history child table. So given the need to log a full snapshot
not only the change of a column I ask you for ideas or suggestion to get
this properly done in Postgresql.

Thanks in advance,

--
Sinceramente,
Josué Maldonado.

... "Toda violación de la verdad no es solamente una especie de suicidio
del embustero, sino una puñalada en la salud de la sociedad humana."
Ralph Waldo Emerson. Filósofo, ensayista, poeta y político EE.UU.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruno Wolff III 2005-03-23 14:12:20 Re: Extracting object source code from database to store in CVS...
Previous Message Lonni J Friedman 2005-03-23 14:05:40 Re: postgres oracle emulation question