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

Commit70de0ab

Browse files
committed
doc: Improve CREATE COLLATION locking documentation
Move out of the concurrency control chapter, where mostly only usertable locks are discussed, and move to CREATE COLLATION reference page.Author: Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>Author: Kyotaro HORIGUCHI <horiguchi.kyotaro@lab.ntt.co.jp>
1 parentc0a5529 commit70de0ab

File tree

2 files changed

+8
-2
lines changed

2 files changed

+8
-2
lines changed

‎doc/src/sgml/mvcc.sgml

Lines changed: 1 addition & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -970,8 +970,7 @@ ERROR: could not serialize access due to read/write dependencies among transact
970970
</para>
971971

972972
<para>
973-
Acquired by <command>CREATE COLLATION</command>,
974-
<command>CREATE TRIGGER</command>, and many forms of
973+
Acquired by <command>CREATE TRIGGER</command> and many forms of
975974
<command>ALTER TABLE</command> (see <xref linkend="sql-altertable"/>).
976975
</para>
977976
</listitem>

‎doc/src/sgml/ref/create_collation.sgml

Lines changed: 7 additions & 0 deletions
Original file line numberDiff line numberDiff line change
@@ -162,6 +162,13 @@ CREATE COLLATION [ IF NOT EXISTS ] <replaceable>name</replaceable> FROM <replace
162162
<refsect1 id="sql-createcollation-notes">
163163
<title>Notes</title>
164164

165+
<para>
166+
<command>CREATE COLLATION</command> takes a <literal>SHARE ROW
167+
EXCLUSIVE</literal> lock, which is self-conflicting, on the
168+
<structname>pg_collation</structname> system catalog, so only one
169+
<command>CREATE COLLATION</command> command can run at a time.
170+
</para>
171+
165172
<para>
166173
Use <command>DROP COLLATION</command> to remove user-defined collations.
167174
</para>

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp