On Wed, Aug 31, 2022 at 11:38:33AM +0200, Peter Eisentraut wrote:
> On 30.08.22 22:42, Bruce Momjian wrote:
> > Good question --- the full text is:
> >
> > <listitem>
> > <para>
> > Record and check the collation of each <link
> > linkend="sql-createdatabase">database</link> (Peter Eisentraut)
> > </para>
> >
> > <para>
> > This is designed to detect collation
> > mismatches to avoid data corruption. Function
> > <function>pg_database_collation_actual_version()</function>
> > reports the underlying operating system collation version, and
> > <command>ALTER DATABASE ... REFRESH</command> sets the database
> > to match the operating system collation version. DETAILS?
> > </para>
> > </listitem>
> >
> > I just can't figure out what the user needs to understand about this,
> > and I understand very little of it.
>
> We already had this feature for (schema-level) collations, now we have it on
> the level of the database collation.
Okay, I figured out the interplay between OS collation version support,
collation libraries, and collation levels. Here is an updated patch for
the release notes.
--
Bruce Momjian <br...@momjian.us> https://momjian.us
EDB https://enterprisedb.com
Indecision is a decision. Inaction is an action. Mark Batterson
diff --git a/doc/src/sgml/release-15.sgml b/doc/src/sgml/release-15.sgml
index e3ab13e53c..dca4550c03 100644
--- a/doc/src/sgml/release-15.sgml
+++ b/doc/src/sgml/release-15.sgml
@@ -578,17 +578,17 @@ Author: Peter Eisentraut <pe...@eisentraut.org>
<listitem>
<para>
- Record and check the collation of each <link
+ Record and check the collation version of each <link
linkend="sql-createdatabase">database</link> (Peter Eisentraut)
</para>
<para>
- This is designed to detect collation
+ This is designed to detect collation version
mismatches to avoid data corruption. Function
<function>pg_database_collation_actual_version()</function>
reports the underlying operating system collation version, and
<command>ALTER DATABASE ... REFRESH</command> sets the database
- to match the operating system collation version. DETAILS?
+ to match the operating system collation version.
</para>
</listitem>
@@ -605,9 +605,11 @@ Author: Peter Eisentraut <pe...@eisentraut.org>
</para>
<para>
- Previously, <acronym>ICU</acronym> collations could only be
- specified in <link linkend="sql-createcollation"><command>CREATE
- COLLATION</command></link> and used with the
+ Previously, only <application>libc</application>-based
+ collations could be set at the cluster and database levels.
+ <acronym>ICU</acronym> collations were previously limited
+ to <link linkend="sql-createcollation"><command>CREATE
+ COLLATION</command></link> and referenced by the
<literal>COLLATE</literal> clause.
</para>
</listitem>
