pgsql: Add a time-of-preparation column to the pg_prepared_xacts view, - Mailing list pgsql-committers

From tgl@svr1.postgresql.org (Tom Lane)
Subject pgsql: Add a time-of-preparation column to the pg_prepared_xacts view,
Date
Msg-id 20050618193343.781DD5283D@svr1.postgresql.org
Whole thread Raw
List pgsql-committers
Log Message:
-----------
Add a time-of-preparation column to the pg_prepared_xacts view, per an
old suggestion by Oliver Jowett.  Also, add a transaction column to the
pg_locks view to show the xid of each transaction holding or awaiting
locks; this allows prepared transactions to be properly associated with
the locks they own.  There was already a column named 'transaction',
and I chose to rename it to 'transactionid' --- since this column is
new in the current devel cycle there should be no backwards compatibility
issue to worry about.

Modified Files:
--------------
    pgsql/doc/src/sgml:
        catalogs.sgml (r2.104 -> r2.105)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/catalogs.sgml.diff?r1=2.104&r2=2.105)
    pgsql/src/backend/access/transam:
        twophase.c (r1.2 -> r1.3)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/access/transam/twophase.c.diff?r1=1.2&r2=1.3)
        xact.c (r1.205 -> r1.206)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/access/transam/xact.c.diff?r1=1.205&r2=1.206)
    pgsql/src/backend/catalog:
        system_views.sql (r1.14 -> r1.15)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/catalog/system_views.sql.diff?r1=1.14&r2=1.15)
    pgsql/src/backend/utils/adt:
        lockfuncs.c (r1.18 -> r1.19)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/lockfuncs.c.diff?r1=1.18&r2=1.19)
    pgsql/src/include/access:
        twophase.h (r1.1 -> r1.2)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/access/twophase.h.diff?r1=1.1&r2=1.2)
    pgsql/src/include/catalog:
        catversion.h (r1.277 -> r1.278)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/include/catalog/catversion.h.diff?r1=1.277&r2=1.278)
    pgsql/src/test/regress/expected:
        rules.out (r1.101 -> r1.102)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/expected/rules.out.diff?r1=1.101&r2=1.102)

pgsql-committers by date:

Previous
From: tgl@svr1.postgresql.org (Tom Lane)
Date:
Subject: pgsql: Dept.
Next
From: tgl@svr1.postgresql.org (Tom Lane)
Date:
Subject: pgsql: When using C-string lookup keys in a dynahash.c hash table, use