public inbox for [email protected]
help / color / mirror / Atom feedFrom: Bruce Momjian <[email protected]>
To: Peter Geoghegan <[email protected]>
Cc: Alvaro Herrera <[email protected]>
Cc: PostgreSQL-documentation <[email protected]>
Subject: Re: Pg_upgrade and collation
Date: Tue, 28 Jun 2016 18:20:11 -0400
Message-ID: <[email protected]> (raw)
In-Reply-To: <CAH2-WznT0JzoRLBVGjUMO_vyFHHAEtHw9QhqFNn4SFAWMoc1Qw@mail.gmail.com>
References: <[email protected]>
<[email protected]>
<CAH2-WznT0JzoRLBVGjUMO_vyFHHAEtHw9QhqFNn4SFAWMoc1Qw@mail.gmail.com>
List-Unsubscribe: <mailto:[email protected]?body=unsub%20pgsql-docs>
On Tue, Jun 28, 2016 at 02:58:58PM -0700, Peter Geoghegan wrote:
> On Fri, Jun 17, 2016 at 2:51 PM, Alvaro Herrera
> <[email protected]> wrote:
> > I think this is way too thin to be helpful:
> >
> >> --- 61,68 ----
> >> checking for compatible compile-time settings, including 32/64-bit
> >> binaries. It is important that
> >> any external modules are also binary compatible, though this cannot
> >> ! be checked by <application>pg_upgrade</>. Compatible collation
> >> ! library versions must also be used.
> >> </para>
>
> Unfortunately, the reality is that as things stand, there is no way to
> test compatibility on all platforms. Glibc does have a notion of
> collation versioning, though [1].
Yes, the patch text is clearly weasel-words in that we can't explain how
to detect incompatible.
> I have long advocated adopting ICU as our defacto standard "collation
> provider", primarily so that we can directly control collations and
> collation versioning. I think that doing this would solve many
> problems. Besides, even SQLite has optional ICU support. PostgreSQL is
> the only major database system that I'm aware of that relies on
> operating system collations exclusively.
I am hopeful ICU has improved enough since we last researched that
support for it will soon be added.
--
Bruce Momjian <[email protected]> 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 +
--
Sent via pgsql-docs mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs
view thread (15+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected]
Subject: Re: Pg_upgrade and collation
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox