aupg - aupg_src: Added support for multi-column primary keys.

From: rlucas(at)pgfoundry(dot)org (User Rlucas)
To: pgsql-committers(at)postgresql(dot)org
Subject: aupg - aupg_src: Added support for multi-column primary keys.
Date: 2007-10-07 01:10:19
Message-ID: 20071007011019.7246D2176A8@pgfoundry.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Log Message:
-----------
Added support for multi-column primary keys.
Reoriented the tuple (row value text) storage to store /previous/
values instead of duplicating the current value in the audited table.
Added TG_OP (operation type) tracking.
Added tracking of pg xid (for possible use in conjunction with st timestamp
for future tracking of legitimized transactions).

Need to write more tests, especially for overlapping alterations of
a row by two sessions (make sure no deadlocks). I don't think there will
be locks but I think that you might have confusing entries in the log.

Modified Files:
--------------
aupg_src/sql:
audit_infrastructure.sql (r1.2 -> r1.3)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/aupg/aupg_src/sql/audit_infrastructure.sql.diff?r1=1.2&r2=1.3)

Browse pgsql-committers by date

  From Date Subject
Next Message Alvaro Herrera 2007-10-07 01:13:30 pgsql: Change π to plain "pi" in index entry, to avoid double
Previous Message Alvaro Herrera 2007-10-07 00:32:11 pgsql: Clean up the doc makefile for draft HTML generation.