Re: pgsql: doc: mention dependency on collation libraries

On Sat, Jul 2, 2016 at 05:39:51PM +0200, Christoph Berg wrote:
> Re: Bruce Momjian 2016-07-02 <E1bJMkm-0001gS-3c(at)gemulon(dot)postgresql(dot)org>
> > doc: mention dependency on collation libraries
> >
> > Document that index storage is dependent on the operating system's
> > collation library ordering, and any change in that ordering can create
> > invalid indexes.
>
> 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".
>
> (German writeup:
> http://www.credativ.de/blog/postgresql-und-inkompatible-deutsche-spracheigenschaften-centosrhel)

Yes, we can do that. Do you have suggested wording? I was not sure how
to tell people anything related to collation versions.

--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com

+ As you are, so once was I. As I am, so you will be. +
+ Ancient Roman grave inscription +