Re: Database Design: Maintain Audit Trail of Changes
| От | Stevo Slavić |
|---|---|
| Тема | Re: Database Design: Maintain Audit Trail of Changes |
| Дата | |
| Msg-id | CAAUywg-SFVZzo+EiAm7=4-1h5LAzJW8qLoBOBqMeLkGYoDRY4w@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Database Design: Maintain Audit Trail of Changes (Craig Ringer <craig@2ndquadrant.com>) |
| Список | pgsql-general |
In Java world, for this purpose I tend to use JPA/Hibernate with Envers http://www.jboss.org/envers - db vendor agnostic solution.
Kind regards,Stevo Slavic.
On Tue, Jan 8, 2013 at 6:32 AM, Craig Ringer <craig@2ndquadrant.com> wrote:
On 4/01/2013 12:09 AM, Adrian Klaver wrote:Additionally, this is an audit trigger I was using internally and
> On 01/03/2013 07:38 AM, Rich Shepard wrote:
>
>>
>> The middleware of the application needs to check this table when data
>> are
>> to be viewed in the UI and present only the current row contents. A
>> separate
>> view would display a history of changes for that row.
>>
>> All thoughts, suggestions, and recommendations based on your
>> expertise and
>> experience will be most welcome.
>
> As a matter of course I include fields to record the timestamp and
> user for insert of records and last update of record on my tables.
>
> For a relatively simple solution see this blog post I put up this summer:
>
> http://aklaver.org/wordpress/2012/06/23/postgres-and-hstore/
>
> I have since expanded that to include updates by using TG_OP to
> determine the operation being done on the table.
>
> There is also pg_audit
> :
> https://github.com/jcasanov/pg_audit
generalized:
http://wiki.postgresql.org/wiki/Audit_trigger_91plus
--
Craig Ringer http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
В списке pgsql-general по дате отправления: