Re: Audit trail

Поиск
Список
Период
Сортировка
Искать
От
Jeff Fitzmyers
Тема
Re: Audit trail
Дата
Msg-id
E2B31091-550A-11D7-9482-000A959C6000@cloverpub.com
Ответ на
Audit trail (James Gregory)
Список
Дерево обсуждения
Audit trail James Gregory <james@anchor.net.au>
Re: Audit trail Joshua Moore-Oliva <josh@chatgris.com>
Re: Audit trail "scott.marlowe" <scott.marlowe@ihs.com>
Re: Audit trail James Thompson <jamest@math.ksu.edu>
Re: Audit trail Jeff Fitzmyers <jeff@cloverpub.com>
Re: Audit trail James Gregory <james@anchor.net.au>
Re: Audit trail Joe Conway <mail@joeconway.com>
> I am wondering if anyone has any good solutions for having postgres
> leave an audit trail.

I had 2 tables that needed a simple audit trail. It was very easy to 
set up using php.

A few lines of code within transactions:
When a row is created, log it.
When any changes happen, log them, who did them and why.

I never felt I needed all the info for each row - just the changes.

Jeff

В списке pgsql-general по дате отправления
От: Joshua Moore-Oliva
Дата:
Сообщение: Re: Audit trail
От: James Gregory
Дата:
Сообщение: Re: Audit trail
FAQ