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)
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. |