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 <bruce@momjian.us> https://momjian.us
EDB https://enterprisedb.com
Indecision is a decision. Inaction is an action. Mark Batterson