aboutsummaryrefslogtreecommitdiff
path: root/doc/src/sgml/ref/create_collation.sgml
diff options
context:
space:
mode:
Diffstat (limited to 'doc/src/sgml/ref/create_collation.sgml')
-rw-r--r--doc/src/sgml/ref/create_collation.sgml7
1 files changed, 7 insertions, 0 deletions
diff --git a/doc/src/sgml/ref/create_collation.sgml b/doc/src/sgml/ref/create_collation.sgml
index 5bc9af5499e..038797fce11 100644
--- a/doc/src/sgml/ref/create_collation.sgml
+++ b/doc/src/sgml/ref/create_collation.sgml
@@ -163,6 +163,13 @@ CREATE COLLATION [ IF NOT EXISTS ] <replaceable>name</replaceable> FROM <replace
<title>Notes</title>
<para>
+ <command>CREATE COLLATION</command> takes a <literal>SHARE ROW
+ EXCLUSIVE</literal> lock, which is self-conflicting, on the
+ <structname>pg_collation</structname> system catalog, so only one
+ <command>CREATE COLLATION</command> command can run at a time.
+ </para>
+
+ <para>
Use <command>DROP COLLATION</command> to remove user-defined collations.
</para>