From 0353f48f0e7c85bc1a053710ed42ab23123b0b7c Mon Sep 17 00:00:00 2001
From: Michael Paquier
Date: Tue, 2 Oct 2018 16:36:11 +0900
Subject: Fix documentation of pgrowlocks using "lock_type" instead of "modes"
The example used in the documentation is outdated as well. This is an
oversight from 0ac5ad5, which bumped up pgrowlocks but forgot some bits
of the documentation.
Reported-by: Chris Wilson
Discussion: https://postgr.es/m/153838692816.2950.12001142346234155699@wrigleys.postgresql.org
Backpatch-through: 9.3
---
doc/src/sgml/pgrowlocks.sgml | 18 +++++++++---------
1 file changed, 9 insertions(+), 9 deletions(-)
(limited to 'doc/src')
diff --git a/doc/src/sgml/pgrowlocks.sgml b/doc/src/sgml/pgrowlocks.sgml
index d73511579c4..d912c3b1236 100644
--- a/doc/src/sgml/pgrowlocks.sgml
+++ b/doc/src/sgml/pgrowlocks.sgml
@@ -63,7 +63,7 @@ pgrowlocks(text) returns setof record
Transaction IDs of lockers (more than one if multitransaction)
- lock_type
+ modes
text[]
Lock mode of lockers (more than one if multitransaction),
an array of Key Share>, Share>,
@@ -120,14 +120,14 @@ SELECT * FROM accounts AS a, pgrowlocks('accounts') AS p
Sample Output
-
-test=# SELECT * FROM pgrowlocks('t1');
- locked_row | lock_type | locker | multi | xids | pids
-------------+-----------+--------+-------+-----------+---------------
- (0,1) | Shared | 19 | t | {804,805} | {29066,29068}
- (0,2) | Shared | 19 | t | {804,805} | {29066,29068}
- (0,3) | Exclusive | 804 | f | {804} | {29066}
- (0,4) | Exclusive | 804 | f | {804} | {29066}
+
+=# SELECT * FROM pgrowlocks('t1');
+ locked_row | locker | multi | xids | modes | pids
+------------+--------+-------+-------+----------------+--------
+ (0,1) | 609 | f | {609} | {"For Share"} | {3161}
+ (0,2) | 609 | f | {609} | {"For Share"} | {3161}
+ (0,3) | 607 | f | {607} | {"For Update"} | {3107}
+ (0,4) | 607 | f | {607} | {"For Update"} | {3107}
(4 rows)
--
cgit v1.2.3