Re: pgsql: doc: mention dependency on collation libraries

From: Christoph Berg <myon(at)debian(dot)org>
To: Bruce Momjian <bruce(at)momjian(dot)us>
Cc: pgsql-committers(at)postgresql(dot)org
Subject: Re: pgsql: doc: mention dependency on collation libraries
Date: 2016-07-02 16:02:12
Message-ID: 20160702160212.GB9700@msg.df7cb.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Re: Bruce Momjian 2016-07-02 <20160702155517(dot)GD18610(at)momjian(dot)us>
> > Shouldn't this mention that OS upgrades are a possible problem as
> > well? We've seen the de_DE.UTF-8 ordering break in RHEL 5->6, and
> > again in 6->7. (5 and 7 are compatible.) The problematic strings were
> > "999" and "9-9-9".
>
> Yes, we can do that. Do you have suggested wording? I was not sure how
> to tell people anything related to collation versions.

How about simply this: ?

Non<literal>C</> and and non-<literal>POSIX</> locales rely on the
operating system's collation library for character set ordering.
This controls the ordering of keys stored in indexes. For this
eason,
a cluster cannot switch to an incompatible collation library
ersion,
either through

+ operating system upgrade,

snapshot restore, binary streaming replication, or
<application>pg_upgrade</> run.

Christoph

In response to

Responses

Browse pgsql-committers by date

  From Date Subject
Next Message Bruce Momjian 2016-07-02 17:22:48 Re: pgsql: doc: mention dependency on collation libraries
Previous Message Bruce Momjian 2016-07-02 15:55:17 Re: pgsql: doc: mention dependency on collation libraries