diff options
| -rw-r--r-- | doc/src/sgml/mvcc.sgml | 3 | ||||
| -rw-r--r-- | doc/src/sgml/ref/create_collation.sgml | 7 |
2 files changed, 8 insertions, 2 deletions
diff --git a/doc/src/sgml/mvcc.sgml b/doc/src/sgml/mvcc.sgml index 24613e3c754..73934e5cf37 100644 --- a/doc/src/sgml/mvcc.sgml +++ b/doc/src/sgml/mvcc.sgml @@ -970,8 +970,7 @@ ERROR: could not serialize access due to read/write dependencies among transact </para> <para> - Acquired by <command>CREATE COLLATION</command>, - <command>CREATE TRIGGER</command>, and many forms of + Acquired by <command>CREATE TRIGGER</command> and many forms of <command>ALTER TABLE</command> (see <xref linkend="sql-altertable"/>). </para> </listitem> 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> |