Add a time-of-preparation column to the pg_prepared_xacts view, per an
Tom Lane <tgl@sss.pgh.pa.us>
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.
Files
| Path | Change | +/− |
|---|---|---|
| doc/src/sgml/catalogs.sgml | modified | +32 −9 |
| src/backend/access/transam/twophase.c | modified | +29 −16 |
| src/backend/access/transam/xact.c | modified | +9 −2 |
| src/backend/catalog/system_views.sql | modified | +8 −7 |
| src/backend/utils/adt/lockfuncs.c | modified | +18 −12 |
| src/include/access/twophase.h | modified | +6 −4 |
| src/include/catalog/catversion.h | modified | +2 −2 |
| src/test/regress/expected/rules.out | modified | +2 −2 |