Log Message:
---
Added line to kill_audit_table to also destroy (cascading) the aupg_*_pk
function
that gets created by make_audit_table. Permits round-trips. Added test.
Modified Files:
--
aupg_src/sql:
audit_infrastructure.sql (r1.21 -> r1.22)
(http://
Log Message:
---
Fixed a bug in the ability to insert/update/delete a row that had not been
previously
listed in the audit table. This is necessary for dropping in AUPG
functionality to
existing tables that have not been previously audited. Added a test case for
this
to the test suite.
Log Message:
---
Update to "actor" system to allow a third way besides "human actor" with
pg_rolname or
software agent file/version (external username).
Modified Files:
--
aupg_src/sql:
audit_infrastructure.sql (r1.19 -> r1.20)
(http://cvs.pgfoundry.org/cg
Log Message:
---
Minor text change
Modified Files:
--
aupg_src:
README (r1.3 -> r1.4)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/aupg/aupg_src/README?r1=1.3&r2=1.4)
--
Sent via pgsql-committers mailing list (pgsql-committers@postgresql.org)
To make chan
Log Message:
---
I am so ashamed to commit this patch. I created a BS function for PG < 8.3 to
prevent the (already hackish) txid code from failing to parse on a not-found
function.
The longer-term solution is probably to eval the code based on version using
plpgsql and 'execute.'
Modif
Log Message:
---
Fixed incompatibility with PostgreSQL 8.3's new transaction id model.
WARNING!
NOTE that the change in storage type from int to bigint for transaction ids
means that this is not a compatible upgrade from previous versions of AuPG.
It should be possible to convert from i
Log Message:
---
added default id=1 entry for trust graph to trust all
Modified Files:
--
aupg_src/sql:
audit_infrastructure.sql (r1.16 -> r1.17)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/aupg/aupg_src/sql/audit_infrastructure.sql.diff?r1=1.16&r2=1.17)
Log Message:
---
Modified the aupgschema.rowid() types to use SQL instead of PLPGSQL because it
looks like a bug in plpgsql prevents the use of rowtypes that contain
composites.
Modified Files:
--
aupg_src/sql:
audit_infrastructure.sql (r1.15 -> r1.16)
(h
Log Message:
---
changed the set_current_sw_actor function not to depend upon the pg_rolname
Modified Files:
--
aupg_src/sql:
audit_infrastructure.sql (r1.14 -> r1.15)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/aupg/aupg_src/sql/audit_infrastructure.sql.d
Log Message:
---
removed augpgschema designation in front of _current_pg_transaction_id()...
Modified Files:
--
aupg_src/sql:
audit_infrastructure.sql (r1.12 -> r1.13)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/aupg/aupg_src/sql/audit_infrastructure.sql.d
Log Message:
---
one more schema change on write-only generated trigger
Modified Files:
--
aupg_src/sql:
audit_infrastructure.sql (r1.13 -> r1.14)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/aupg/aupg_src/sql/audit_infrastructure.sql.diff?r1=1.13&r2=1.14)
Log Message:
---
fixed reference in trigger function to aupgschema.write rather than implied
public.write.
Modified Files:
--
aupg_src/sql:
audit_infrastructure.sql (r1.11 -> r1.12)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/aupg/aupg_src/sql/audit_infra
Log Message:
---
Fixed failing test in timetravel function code. It was not properly filtering
rows and was always returning the latest row.
Modified Files:
--
aupg_src/sql:
audit_infrastructure.sql (r1.10 -> r1.11)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb
Log Message:
---
moved functions for pk comparison operators into aupgschema schema
Modified Files:
--
aupg_src/sql:
audit_infrastructure.sql (r1.9 -> r1.10)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/aupg/aupg_src/sql/audit_infrastructure.sql.diff?r1=1.9
Log Message:
---
Changed write table to be primary key'ed on transaction id and timestamp.
Fixed a bug where multiple writes could possibly have been logged for a single
transaction id / timestamp combo.
Modified Files:
--
aupg_src/sql:
audit_infrastructure.sql (r1.
Log Message:
---
Added tests for multicolumn primary keys, which promptly broke. Reworked some
pk comparison
bits to rely upon Postgres' own comparison rather than getting into ugly
record_in(textout('(blah)'), 'typename'::regtype::oid, 0) nonsense
Modified Files:
--
aup
Log Message:
---
props where props due
Modified Files:
--
aupg_src:
README (r1.2 -> r1.3)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/aupg/aupg_src/README.diff?r1=1.2&r2=1.3)
---(end of broadcast)---
TIP 4:
Log Message:
---
Added a bunch of tests. Also created the timetravel function for an audited
table
and added tests for that. Nearing usability for EARLY work (still in dangerous
flux; do not use in production).
Modified Files:
--
aupg_src/sql:
_test_takedown.sql
Log Message:
---
Cut out deprecated definitions. Prefixed aupgschema. to MOST
function definitions; did not change a few ones that could be general
to other uses and which are highly unlikely to suffer name conflicts.
Modified Files:
--
aupg_src/sql:
audit_infrastr
Log Message:
---
Discovered that the text types were not easily converible back into the
compound PK types. Ended up having to create wrapper operators for the
standard "row" comparison operators.
Modified Files:
--
aupg_src/sql:
_test_setup.sql (r1.2 -> r1.3)
Log Message:
---
Added a rudimentary testing infrastructure. If this were SVN I would move files
around and rename them to clarify, but for now we'll keep the structure as is.
In a nutshell, alltest.pl uses Test::Harness to run all the *.t files in the
current dir. You make a *.t file by
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 conjunct
Log Message:
---
Reformatted for POD -> LaTeX
Modified Files:
--
aupg_src/sql:
audit_infrastructure.sql (r1.1 -> r1.2)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/aupg/aupg_src/sql/audit_infrastructure.sql.diff?r1=1.1&r2=1.2)
---(e
Log Message:
---
scaffolding files for running "transactional" tests.
Added Files:
---
aupg_src/sql:
_transactional_test_setup.sql (r1.1)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/aupg/aupg_src/sql/_transactional_test_setup.sql?rev=1.1&content-type=text/x-cv
Log Message:
---
Cleaned up and document RWL work to date. Works well for plain vanilla
schemata.
Added Files:
---
aupg_src/sql:
_test_setup.sql (r1.1)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/aupg/aupg_src/sql/_test_setup.sql?rev=1.1&content-type=text/x-
Update of /cvsroot/aupg/aupg_src/bin
In directory pgfoundry.org:/tmp/cvs-serv12107/bin
Log Message:
Directory /cvsroot/aupg/aupg_src/bin added to the repository
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your des
Update of /cvsroot/aupg/aupg_src/doc
In directory pgfoundry.org:/tmp/cvs-serv83240/doc
Log Message:
Directory /cvsroot/aupg/aupg_src/doc added to the repository
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appro
Update of /cvsroot/aupg/aupg_src/sql
In directory pgfoundry.org:/tmp/cvs-serv82768/sql
Log Message:
Directory /cvsroot/aupg/aupg_src/sql added to the repository
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
Log Message:
---
Modified Files:
--
aupg_src:
LICENSE (r1.1.1.1 -> r1.2)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/aupg/aupg_src/LICENSE.diff?r1=1.1.1.1&r2=1.2)
README (r1.1.1.1 -> r1.2)
(http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/aupg
Update of /cvsroot/aupg/aupg_src
In directory pgfoundry.org:/tmp/cvs-serv59864
Log Message:
Skeleton
Status:
Vendor Tag: voyager
Release Tags: initial
N aupg_src/README
N aupg_src/LICENSE
No conflicts created by this import
---(end of broadcast)-
30 matches
Mail list logo
