audit system for parent-child tables

From: josue <josue(at)lamundial(dot)hn>
To: PgSQL General List <pgsql-general(at)postgresql(dot)org>
Subject: audit system for parent-child tables
Date: 2006-03-14 20:35:56
Message-ID: 4417292C.20601@lamundial.hn
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello list,

I have the need to audit a purchase order process that mainly deals with
PO header and details table, users need to know at any given time how
the purchase order was, like a snapshot, I already log any change to a
separate parallel table.

One way I could do is log each change in both tables a insert in the
audit tables each row in the detail and the row of the header, but that
way could generate a lot of data,

any idea or suggestion to get this done in postgresql ?

Thanks in advance

--
Sinceramente,
Josué Maldonado.

... "El verdadero placer está en la búsqueda, más que en la
explicación." -- Isaac Asimov

Browse pgsql-general by date

  From Date Subject
Next Message Wes 2006-03-14 20:43:23 Re: Wisconsin Circuit Court Access (WCCA) on
Previous Message Ycrux 2006-03-14 20:28:24 Re: Turn OFF Stats of Postgresql