| 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: | Whole Thread | Raw Message | 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.
| 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 |