Обсуждение: pgsql: Add a time-of-preparation column to the pg_prepared_xacts view,

Поиск
Список
Период
Сортировка

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

От
tgl@svr1.postgresql.org (Tom Lane)
Дата:
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)