Movatterモバイル変換


[0]ホーム

URL:


Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Sign up
Appearance settings

Commitc1129a1

Browse files
committed
Doc clarification for pg_locks columns.
Florian Pflug
1 parent8d26091 commitc1129a1

File tree

1 file changed

+21
-19
lines changed

1 file changed

+21
-19
lines changed

‎doc/src/sgml/catalogs.sgml

Lines changed: 21 additions & 19 deletions
Original file line numberDiff line numberDiff line change
@@ -6928,71 +6928,72 @@
69286928
<entry><type>oid</type></entry>
69296929
<entry><literal><link linkend="catalog-pg-database"><structname>pg_database</structname></link>.oid</literal></entry>
69306930
<entry>
6931-
OID of the database in which theobject exists, or
6932-
zero if theobject is a shared object, or
6933-
null if thelock object is on a transaction ID
6931+
OID of the database in which thelock target exists, or
6932+
zero if thetarget is a shared object, or
6933+
null if thetarget is a transaction ID
69346934
</entry>
69356935
</row>
69366936
<row>
69376937
<entry><structfield>relation</structfield></entry>
69386938
<entry><type>oid</type></entry>
69396939
<entry><literal><link linkend="catalog-pg-class"><structname>pg_class</structname></link>.oid</literal></entry>
69406940
<entry>
6941-
OID of the relation, or null if thelock object is not
6942-
ona relation or part of a relation
6941+
OID of the relation targeted by the lock, or null if thetarget is not
6942+
a relation or part of a relation
69436943
</entry>
69446944
</row>
69456945
<row>
69466946
<entry><structfield>page</structfield></entry>
69476947
<entry><type>integer</type></entry>
69486948
<entry></entry>
69496949
<entry>
6950-
Page numberwithintherelation, or null ifthelock object
6951-
is not on a tuple orrelation page
6950+
Page numbertargeted bythelock withintherelation,
6951+
or null if the target is not arelation page or tuple
69526952
</entry>
69536953
</row>
69546954
<row>
69556955
<entry><structfield>tuple</structfield></entry>
69566956
<entry><type>smallint</type></entry>
69576957
<entry></entry>
69586958
<entry>
6959-
Tuple numberwithin the page, or null ifthe lockobject is not
6960-
on a tuple
6959+
Tuple numbertargeted bythe lockwithin the page,
6960+
or null if the target is not a tuple
69616961
</entry>
69626962
</row>
69636963
<row>
69646964
<entry><structfield>virtualxid</structfield></entry>
69656965
<entry><type>text</type></entry>
69666966
<entry></entry>
69676967
<entry>
6968-
Virtual ID ofa transactionlock, or null ifthe lock object is not
6969-
on a virtual transaction ID
6968+
Virtual ID ofthe transactiontargeted bythe lock,
6969+
or null if the target is not a virtual transaction ID
69706970
</entry>
69716971
</row>
69726972
<row>
69736973
<entry><structfield>transactionid</structfield></entry>
69746974
<entry><type>xid</type></entry>
69756975
<entry></entry>
69766976
<entry>
6977-
ID of a transaction lock, or null if the lock object is not on a transaction ID
6977+
ID of the transaction targeted by the lock,
6978+
or null if the target is not a transaction ID
69786979
</entry>
69796980
</row>
69806981
<row>
69816982
<entry><structfield>classid</structfield></entry>
69826983
<entry><type>oid</type></entry>
69836984
<entry><literal><link linkend="catalog-pg-class"><structname>pg_class</structname></link>.oid</literal></entry>
69846985
<entry>
6985-
OID of the system catalog containing theobject, or null if the
6986-
lock objectis notona general database object.
6986+
OID of the system catalog containing thelock target, or null if the
6987+
targetis not a general database object
69876988
</entry>
69886989
</row>
69896990
<row>
69906991
<entry><structfield>objid</structfield></entry>
69916992
<entry><type>oid</type></entry>
69926993
<entry>any OID column</entry>
69936994
<entry>
6994-
OID of theobject within its system catalog, or null if the
6995-
lock objectis not on a general database object.
6995+
OID of thelock target within its system catalog, or null if the
6996+
targetis not a general database object.
69966997
For advisory locks it is used to distinguish the two key
69976998
spaces (1 for an int8 key, 2 for two int4 keys).
69986999
</entry>
@@ -7002,10 +7003,11 @@
70027003
<entry><type>smallint</type></entry>
70037004
<entry></entry>
70047005
<entry>
7005-
For a table column, this isthecolumn number (the
7006+
Column number targeted bythelock (the
70067007
<structfield>classid</> and <structfield>objid</> refer to the
7007-
table itself). For all other object types, this column is
7008-
zero. Null if the lock object is not on a general database object.
7008+
table itself),
7009+
or zero if the target is some other general database object,
7010+
or null if the target is not a general database object
70097011
</entry>
70107012
</row>
70117013
<row>

0 commit comments

Comments
 (0)

[8]ページ先頭

©2009-2025 Movatter.jp