BUG #9840: Documentation bug on pg_locks

From: bashtanov(at)imap(dot)cc
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #9840: Documentation bug on pg_locks
Date: 2014-04-03 08:04:25
Message-ID: 20140403080425.309.11395@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 9840
Logged by: Alexey Bashtanov
Email address: bashtanov(at)imap(dot)cc
PostgreSQL version: 9.3.4
Operating system: -
Description:

Hello!
Documentation
http://www.postgresql.org/docs/current/static/view-pg-locks.html states that
"if you are using prepared transactions, the transaction column can be
joined to the transaction column of the pg_prepared_xacts view to get more
information on prepared transactions that hold locks."

However, there is no "transaction" column in pg_locks.

Neither transactionid nor virtualtransaction could be the mentioned column
as transactionid is "null if the target is not a transaction ID" and
virtualtransaction has different column data type.

Please could you clarify the docs.

Regards,
Alexey Bashtanov

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message kurasanthoshkumar 2014-04-03 08:09:11 BUG #9841: Need some help in sql query
Previous Message sidicas2 2014-04-02 22:40:06 BUG #9836: SegFault at heaptouple.c:1104