pg.ddx.io  pgsql-hackers@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Doug Doole <ddoole@salesforce.com>
Cc: Craig Ringer <craig@2ndquadrant.com>
Cc: pgsql-hackers <pgsql-hackers@postgresql.org>
Subject: Re: ICU integration
Date: Thu, 8 Sep 2016 12:19:39 -0400
Message-ID: <9caee847-7a64-a71a-d4ce-a269b04a3a8c@2ndquadrant.com> (raw)
In-Reply-To: <3006.1473347760@sss.pgh.pa.us>
References: <85364fde-091f-bbc0-fec2-e3ede39840a6@2ndquadrant.com>
	<CAMsr+YE27yoX7fF40k+5swo+2cWguV0j6jtkWKj7RRowYGo9Sg@mail.gmail.com>
	<f0e24354-31f1-47cd-c384-e41d72d43e83@2ndquadrant.com>
	<51759C7D-BE9E-4173-B5F9-EFD7B9594C2B@salesforce.com>
	<f0adba2a-0846-cbbc-06eb-0f938c119aa9@2ndquadrant.com>
	<CAP6UvaNTvYXmsJTiDQKwKTBJhO-axRXBjWTXJ5oAonSFNJ514g@mail.gmail.com>
	<6008673a-e371-8437-adc0-96fba4a74028@2ndquadrant.com>
	<3006.1473347760@sss.pgh.pa.us>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-hackers>

On 9/8/16 11:16 AM, Tom Lane wrote:
> This is a problem, if ICU won't guarantee cross-version compatibility,
> because it destroys the argument that moving to ICU would offer us
> collation behavior stability.

It would offer a significant upgrade over the current situation.

First, it offers stability inside the same version.  Whereas glibc might
change a collation in a minor upgrade, ICU won't do that.  And the
postgres binary is bound to a major version of ICU by the soname (which
changes with every major release).  So this would avoid the situation
that a simple OS update could break collations.

Second, it offers a way to detect that something has changed.  With
glibc, you don't know anything unless you read the source diffs.  With
ICU, you can compare the collation version before and after and at least
tell the user that they need to refresh indexes or whatever.

-- 
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers



view thread (83+ messages)  latest in thread

Message-ID: <9caee847-7a64-a71a-d4ce-a269b04a3a8c@2ndquadrant.com>
Permalink:  ../9caee847-7a64-a71a-d4ce-a269b04a3a8c@2ndquadrant.com/
Also on:    postgresql.org/message-id/9caee847-7a64-a71a-d4ce-a269b04a3a8c@2ndquadrant.com

 · 

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: pgsql-hackers@postgresql.org
  Cc: peter.eisentraut@2ndquadrant.com, tgl@sss.pgh.pa.us, ddoole@salesforce.com, craig@2ndquadrant.com
  Subject: Re: ICU integration
  In-Reply-To: <9caee847-7a64-a71a-d4ce-a269b04a3a8c@2ndquadrant.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox