]> git.ipfire.org Git - thirdparty/postgresql.git/commit
Fix documentation about joining pg_locks to other views.
authorTom Lane <tgl@sss.pgh.pa.us>
Thu, 3 Apr 2014 18:18:45 +0000 (14:18 -0400)
committerTom Lane <tgl@sss.pgh.pa.us>
Thu, 3 Apr 2014 18:18:45 +0000 (14:18 -0400)
commit0de9963b0b4e692e6c712a7bb1ee0faf61afa9f0
tree376c0053793187fdc3a07efe618f88a7b01e12df
parent640c0d20a17a0fcfc634b07319841727135b383a
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
doc/src/sgml/catalogs.sgml