🌐 AI搜索 & 代理 主页
Skip to content

Commit 9b9cd9c

Browse files
bmomjianbmomjian
committed
Update "Conflicting lock modes" to show as conflict, add
current/requested headings, add link to table from text.
1 parent 49451ae commit 9b9cd9c

File tree

1 file changed

+93
-93
lines changed

1 file changed

+93
-93
lines changed

‎doc/src/sgml/mvcc.sgml‎

Lines changed: 93 additions & 93 deletions
Original file line numberDiff line numberDiff line change
@@ -1,4 +1,4 @@
1-
<!-- $PostgreSQL: pgsql/doc/src/sgml/mvcc.sgml,v 2.68 2007/02/16 03:50:29 momjian Exp $ -->
1+
<!-- $PostgreSQL: pgsql/doc/src/sgml/mvcc.sgml,v 2.69 2007/02/18 01:21:49 momjian Exp $ -->
22

33
<chapter id="mvcc">
44
<title>Concurrency Control</title>
@@ -536,7 +536,8 @@ SELECT SUM(value) FROM mytab WHERE class = 2;
536536
To some extent the names reflect the typical usage of each lock
537537
mode &mdash; but the semantics are all the same. The only real difference
538538
between one lock mode and another is the set of lock modes with
539-
which each conflicts. Two transactions cannot hold locks of conflicting
539+
which each conflicts (see <xref linkend="table-lock-compatibility">).
540+
. Two transactions cannot hold locks of conflicting
540541
modes on the same table at the same time. (However, a transaction
541542
never conflicts with itself. For example, it might acquire
542543
<literal>ACCESS EXCLUSIVE</literal> lock and later acquire
@@ -741,119 +742,118 @@ SELECT SUM(value) FROM mytab WHERE class = 2;
741742
releases locks acquired within it.
742743
</para>
743744

745+
746+
744747
<table tocentry="1" id="table-lock-compatibility">
745-
<title> Compatibility of lock modes</title>
748+
<title> Conflicting lock modes</title>
746749
<tgroup cols="9">
747-
<colspec colnum="1" colwidth="1*">
748-
<colspec colnum="2" colwidth="1*">
749-
<colspec colnum="3" colwidth="1*">
750-
<colspec colnum="4" colwidth="1*">
751-
<colspec colnum="5" colwidth="1*">
752-
<colspec colnum="6" colwidth="1*">
753-
<colspec colnum="7" colwidth="1*">
754-
<colspec colnum="8" colwidth="1*">
755-
<colspec colnum="9" colwidth="1*">
750+
<colspec colnum="2" colname="lockst">
751+
<colspec colnum="9" colname="lockend">
752+
<spanspec namest="lockst" nameend="lockend" spanname="lockreq">
756753
<thead>
757754
<row>
758-
<entry>Modes</entry>
759-
<entry>AS</entry>
760-
<entry>RS</entry>
761-
<entry>RE</entry>
762-
<entry>SUE</entry>
763-
<entry>S</entry>
764-
<entry>SRE</entry>
765-
<entry>E</entry>
766-
<entry>AE</entry>
755+
<entry morerows="1">Requested Lock Mode</entry>
756+
<entry spanname="lockreq">Current Lock Mode</entry>
757+
</row>
758+
<row>
759+
<entry>ACCESS SHARE</entry>
760+
<entry>ROW SHARE</entry>
761+
<entry>ROW EXCLUSIVE</entry>
762+
<entry>SHARE UPDATE EXCLUSIVE</entry>
763+
<entry>SHARE</entry>
764+
<entry>SHARE ROW EXCLUSIVE</entry>
765+
<entry>EXCLUSIVE</entry>
766+
<entry>ACCESS EXCLUSIVE</entry>
767767
</row>
768768
</thead>
769769
<tbody>
770770
<row>
771-
<entry>AS</entry>
772-
<entry align="center">Y</entry>
773-
<entry align="center">Y</entry>
774-
<entry align="center">Y</entry>
775-
<entry align="center">Y</entry>
776-
<entry align="center">Y</entry>
777-
<entry align="center">Y</entry>
778-
<entry align="center">Y</entry>
779-
<entry align="center">N</entry>
771+
<entry>ACCESS SHARE</entry>
772+
<entry align="center"></entry>
773+
<entry align="center"></entry>
774+
<entry align="center"></entry>
775+
<entry align="center"></entry>
776+
<entry align="center"></entry>
777+
<entry align="center"></entry>
778+
<entry align="center"></entry>
779+
<entry align="center">X</entry>
780780
</row>
781781
<row>
782-
<entry>RS</entry>
783-
<entry align="center">Y</entry>
784-
<entry align="center">Y</entry>
785-
<entry align="center">Y</entry>
786-
<entry align="center">Y</entry>
787-
<entry align="center">Y</entry>
788-
<entry align="center">Y</entry>
789-
<entry align="center">N</entry>
790-
<entry align="center">N</entry>
782+
<entry>ROW SHARE</entry>
783+
<entry align="center"></entry>
784+
<entry align="center"></entry>
785+
<entry align="center"></entry>
786+
<entry align="center"></entry>
787+
<entry align="center"></entry>
788+
<entry align="center"></entry>
789+
<entry align="center">X</entry>
790+
<entry align="center">X</entry>
791791
</row>
792792
<row>
793-
<entry>RE</entry>
794-
<entry align="center">Y</entry>
795-
<entry align="center">Y</entry>
796-
<entry align="center">Y</entry>
797-
<entry align="center">Y</entry>
798-
<entry align="center">N</entry>
799-
<entry align="center">N</entry>
800-
<entry align="center">N</entry>
801-
<entry align="center">N</entry>
793+
<entry>ROW EXCLUSIVE</entry>
794+
<entry align="center"></entry>
795+
<entry align="center"></entry>
796+
<entry align="center"></entry>
797+
<entry align="center"></entry>
798+
<entry align="center">X</entry>
799+
<entry align="center">X</entry>
800+
<entry align="center">X</entry>
801+
<entry align="center">X</entry>
802802
</row>
803803
<row>
804-
<entry>SUE</entry>
805-
<entry align="center">Y</entry>
806-
<entry align="center">Y</entry>
807-
<entry align="center">Y</entry>
808-
<entry align="center">N</entry>
809-
<entry align="center">N</entry>
810-
<entry align="center">N</entry>
811-
<entry align="center">N</entry>
812-
<entry align="center">N</entry>
804+
<entry>SHARE UPDATE EXCLUSIVE</entry>
805+
<entry align="center"></entry>
806+
<entry align="center"></entry>
807+
<entry align="center"></entry>
808+
<entry align="center">X</entry>
809+
<entry align="center">X</entry>
810+
<entry align="center">X</entry>
811+
<entry align="center">X</entry>
812+
<entry align="center">X</entry>
813813
</row>
814814
<row>
815-
<entry>S</entry>
816-
<entry align="center">Y</entry>
817-
<entry align="center">Y</entry>
818-
<entry align="center">N</entry>
819-
<entry align="center">N</entry>
820-
<entry align="center">Y</entry>
821-
<entry align="center">N</entry>
822-
<entry align="center">N</entry>
823-
<entry align="center">N</entry>
815+
<entry>SHARE</entry>
816+
<entry align="center"></entry>
817+
<entry align="center"></entry>
818+
<entry align="center">X</entry>
819+
<entry align="center">X</entry>
820+
<entry align="center"></entry>
821+
<entry align="center">X</entry>
822+
<entry align="center">X</entry>
823+
<entry align="center">X</entry>
824824
</row>
825825
<row>
826-
<entry>SRE</entry>
827-
<entry align="center">Y</entry>
828-
<entry align="center">Y</entry>
829-
<entry align="center">N</entry>
830-
<entry align="center">N</entry>
831-
<entry align="center">N</entry>
832-
<entry align="center">N</entry>
833-
<entry align="center">N</entry>
834-
<entry align="center">N</entry>
826+
<entry>SHARE ROW EXCLUSIVE</entry>
827+
<entry align="center"></entry>
828+
<entry align="center"></entry>
829+
<entry align="center">X</entry>
830+
<entry align="center">X</entry>
831+
<entry align="center">X</entry>
832+
<entry align="center">X</entry>
833+
<entry align="center">X</entry>
834+
<entry align="center">X</entry>
835835
</row>
836836
<row>
837-
<entry>E</entry>
838-
<entry align="center">Y</entry>
839-
<entry align="center">N</entry>
840-
<entry align="center">N</entry>
841-
<entry align="center">N</entry>
842-
<entry align="center">N</entry>
843-
<entry align="center">N</entry>
844-
<entry align="center">N</entry>
845-
<entry align="center">N</entry>
837+
<entry>EXCLUSIVE</entry>
838+
<entry align="center"></entry>
839+
<entry align="center">X</entry>
840+
<entry align="center">X</entry>
841+
<entry align="center">X</entry>
842+
<entry align="center">X</entry>
843+
<entry align="center">X</entry>
844+
<entry align="center">X</entry>
845+
<entry align="center">X</entry>
846846
</row>
847847
<row>
848-
<entry>AE</entry>
849-
<entry align="center">N</entry>
850-
<entry align="center">N</entry>
851-
<entry align="center">N</entry>
852-
<entry align="center">N</entry>
853-
<entry align="center">N</entry>
854-
<entry align="center">N</entry>
855-
<entry align="center">N</entry>
856-
<entry align="center">N</entry>
848+
<entry>ACCESS EXCLUSIVE</entry>
849+
<entry align="center">X</entry>
850+
<entry align="center">X</entry>
851+
<entry align="center">X</entry>
852+
<entry align="center">X</entry>
853+
<entry align="center">X</entry>
854+
<entry align="center">X</entry>
855+
<entry align="center">X</entry>
856+
<entry align="center">X</entry>
857857
</row>
858858
</tbody>
859859
</tgroup>

0 commit comments

Comments
 (0)