Postgres Pro
Downloads
Home   >   mailing lists

Thread: Keep history of modifications

Keep history of modifications

From
"Daniel Devico"
Date:
Hye,

Is there a way to keep in a log file the history of all data changes (for
example keeping sql INSERT, DELETE or UPDATE) as would do dump, keeping
trace of the user who did it and when ?

Daniel

Re: Keep history of modifications

From
Duane Lee - EGOVX
Date:

Write an audit trigger to insert the required data into a table.  I'm doing that myself for a table holding budget ledger data and will be creating the same concept for other tables.

Duane

-----Original Message-----
From: Daniel Devico [mailto:danico.info@free.fr]
Sent: Friday, June 11, 2004 2:25 AM
To: pgsql-general@postgresql.org
Subject: [GENERAL] Keep history of modifications

Hye,

Is there a way to keep in a log file the history of all data changes (for
example keeping sql INSERT, DELETE or UPDATE) as would do dump, keeping
trace of the user who did it and when ?

Daniel

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
      joining column's datatypes do not match