Movatterモバイル変換

[0]ホーム
URL:

Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

 Sign up
Appearance settings

Commitb65431c

Browse files
committed
Doc: Update notes about libc collation versions.
The per-index collation version tracking feature was reverted, but westill have the ability to ask Windows (352f6f2) and FreeBSD(ca051d8) for collation versions to store in pg_collation.collversion.So, from the reverted patch, take a few words of documentation aboutlibc on all three supported OSes to replace the pre-existing note thatmentioned only glibc.Discussion:https://postgr.es/m/CA%2BhUKGLhj5t1fcjqAu8iD9B3ixJtsTNqyCCD4V0aTO9kAKAjjA%40mail.gmail.com
1 parentec48314 commitb65431c

File tree

1 file changed

+17
-5
lines changed

1 file changed

+17
-5
lines changed

‎doc/src/sgml/ref/alter_collation.sgml

Lines changed: 17 additions & 5 deletions
Original file line numberDiff line numberDiff line change
@@ -129,12 +129,24 @@ HINT: Rebuild all objects affected by this collation and run ALTER COLLATION pg
129129
correctly.
130130
</para>
131131
<para>
132-
When using collations provided by <literal>libc</literal> and
133-
<productname>PostgreSQL</productname> was built with the GNU C library, the
134-
C library's version is used as a collation version. Since collation
135-
definitions typically change only with GNU C library releases, this provides
136-
some defense against corruption, but it is not completely reliable.
132+
When using collations provided by <literal>libc</literal>, version
133+
information is recorded on systems using the GNU C library (most Linux
134+
systems), FreeBSD and Windows.
137135
</para>
136+
<note>
137+
<para>
138+
When using the GNU C library for collations, the C library's version
139+
is used as a proxy for the collation version. Many Linux distributions
140+
change collation definitions only when upgrading the C library, but this
141+
approach is imperfect as maintainers are free to back-port newer
142+
collation definitions to older C library releases.
143+
</para>
144+
<para>
145+
When using Windows for collations, version information is only available
146+
for collations defined with BCP 47 language tags such as
147+
<literal>en-US</literal>.
148+
</para>
149+
</note>
138150
<para>
139151
Currently, there is no version tracking for the database default collation.
140152
</para>

0 commit comments

Comments
 (0)
[8]ページ先頭
©2009-2025 Movatter.jp