Обсуждение: 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)