@@ -104,9 +104,9 @@ ALTER COLLATION <replaceable>name</replaceable> SET SCHEMA <replaceable>new_sche
104
104
<title>Notes</title>
105
105
106
106
<para>
107
- Whenusing collations provided by the ICU library , theICU -specific version
108
- of the collator is recorded in the system catalog when the collationobject
109
- is created. When the collation is used, the current version is
107
+ Whena collation object is created , theprovider -specific version of the
108
+ collation is recorded in the system catalog. When the collationis used,
109
+ the current version is
110
110
checked against the recorded version, and a warning is issued when there is
111
111
a mismatch, for example:
112
112
<screen>
@@ -117,21 +117,24 @@ HINT: Rebuild all objects affected by this collation and run ALTER COLLATION pg
117
117
A change in collation definitions can lead to corrupt indexes and other
118
118
problems because the database system relies on stored objects having a
119
119
certain sort order. Generally, this should be avoided, but it can happen
120
- in legitimate circumstances, such as when
120
+ in legitimate circumstances, such as when upgrading the operating system
121
+ to a new major version or when
121
122
using <command>pg_upgrade</command> to upgrade to server binaries linked
122
123
with a newer version of ICU. When this happens, all objects depending on
123
124
the collation should be rebuilt, for example,
124
125
using <command>REINDEX</command>. When that is done, the collation version
125
126
can be refreshed using the command <literal>ALTER COLLATION ... REFRESH
126
127
VERSION</literal>. This will update the system catalog to record the
127
- currentcollator version and will make the warning go away. Note that this
128
+ currentcollation version and will make the warning go away. Note that this
128
129
does not actually check whether all affected objects have been rebuilt
129
130
correctly.
130
131
</para>
131
132
<para>
132
133
When using collations provided by <literal>libc</literal>, version
133
134
information is recorded on systems using the GNU C library (most Linux
134
- systems), FreeBSD and Windows.
135
+ systems), FreeBSD and Windows. When using collations provided by ICU, the
136
+ version information is provided by the ICU library and is available on all
137
+ platforms.
135
138
</para>
136
139
<note>
137
140
<para>