pgsql: Fix documentation about joining pg_locks to other views. - Mailing list pgsql-committers

From Tom Lane
Subject pgsql: Fix documentation about joining pg_locks to other views.
Date
Msg-id E1WVmER-0008Oa-FM@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Fix documentation about joining pg_locks to other views.

The advice to join to pg_prepared_xacts via the transaction column was not
updated when the transaction column was replaced by virtualtransaction.
Since it's not quite obvious how to do that join, give an explicit example.
For consistency also give an example for the adjacent case of joining to
pg_stat_activity.  And link-ify the view references too, just because we
can.  Per bug #9840 from Alexey Bashtanov.

Michael Paquier and Tom Lane

Branch
------
REL9_3_STABLE

Details
-------
http://git.postgresql.org/pg/commitdiff/2186533911ccf71a1ac0ac5b90420a0b76456631

Modified Files
--------------
doc/src/sgml/catalogs.sgml |   25 ++++++++++++++++++-------
1 file changed, 18 insertions(+), 7 deletions(-)


pgsql-committers by date:

Previous
From: Tom Lane
Date:
Subject: pgsql: Fix documentation about joining pg_locks to other views.
Next
From: Tom Lane
Date:
Subject: pgsql: Code review for commit d26888bc4d1e539a82f21382b0000fe5bbf889d9.