| 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: | Whole Thread | Raw Message | 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
| 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 |