Re: Auditing and Postgres 7.3

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

> I've been thinking implementing auditing for Postgres 7.3 and wanted to
> see if anyone had any thoughts about it.
< snip >
> So what would an audit trail consist of?
>
> timestamp
> query type
> query
> query result (successful|unsuccessful)
> audit object oid

We have implemented an audit trail at the application level several times for 
several different projects.  While what you have described in this thread is 
more aimed at debugging, what we have used it for is to see who changed what 
value to what when.  We can show the complete history of all the values for 
parts of our schema, and who changed them when.  Very useful for a number of 
situation.  This I would be a nice feature to have the database manage.  
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (GNU/Linux)
Comment: For info see http://www.gnupg.org

iD8DBQE8Tty+8BXvT14W9HARAoFVAJ9fMHF9q0QhcRQSdmmGbTZX3P1vyACgkquy
WU0WElwZoF6LOP9yNgIvf1c=
=RazC
-----END PGP SIGNATURE-----