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