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

From: tgl(at)svr1(dot)postgresql(dot)org (Tom Lane)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Add a time-of-preparation column to the pg_prepared_xacts view,
Date: 2005-06-18 19:33:43
Message-ID: 20050618193343.781DD5283D@svr1.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers pgsql-hackers

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)

Responses

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2005-06-18 20:10:04 pg_locks column names
Previous Message Tom Lane 2005-06-18 05:21:09 pgsql: Dept.

Browse pgsql-hackers by date

  From Date Subject
Next Message Greg Stark 2005-06-18 19:44:12 Re: Utility database (Was: RE: Autovacuum in the backend)
Previous Message Juan Pablo Espino 2005-06-18 19:33:03 Re: Login/logout