Subject: Re: ICU integration
To: Peter Geoghegan <pg@heroku.com>, Craig Ringer <craig@2ndquadrant.com>
References: <3006.1473347760@sss.pgh.pa.us>
 <9caee847-7a64-a71a-d4ce-a269b04a3a8c@2ndquadrant.com>
 <CAMsr+YHdGQ+ZCmwxK45sTpE-1FOapXyaht+fhEcFccK8+HDKBw@mail.gmail.com>
 <20160909.095154.1130083428657813367.t-ishii@sraoss.co.jp>
 <CAMsr+YHRM5wDNm0TsA3KoPEKPThRO2NtfbiTCHjw8aZxhq_cwQ@mail.gmail.com>
 <CAM3SWZQVv3s70tJ6WCmbcO8cVQjnj8ZruVMBNOqc1YpGmq7hFQ@mail.gmail.com>
Cc: Tatsuo Ishii <ishii@sraoss.co.jp>, Tom Lane <tgl@sss.pgh.pa.us>,
 Doug Doole <ddoole@salesforce.com>,
 PostgreSQL Hackers <pgsql-hackers@postgresql.org>,
 =?UTF-8?B?RGV2cmltIEfDvG5kw7x6?= <devrim@gunduz.org>
From: Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Organization: 2ndQuadrant
Message-ID: <08dc02e5-3347-666d-7eae-ea08b8e8a64e@2ndquadrant.com>
Date: Fri, 9 Sep 2016 08:45:54 -0400
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.11; rv:45.0)
 Gecko/20100101 Thunderbird/45.3.0
MIME-Version: 1.0
In-Reply-To: 
 <CAM3SWZQVv3s70tJ6WCmbcO8cVQjnj8ZruVMBNOqc1YpGmq7hFQ@mail.gmail.com>
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
Precedence: bulk
Sender: pgsql-hackers-owner@postgresql.org

On 9/8/16 11:08 PM, Peter Geoghegan wrote:
> In principle, and assuming I haven't gotten something wrong, it ought
> to be possible to unambiguously identify a collation based on a
> matching UCA version (i.e. DUCET table), plus the collation tailorings
> matching exactly, even across ICU versions that happen to be based on
> the same UCA version (they only seem to put out a new UCA version
> about once a year [4]).  It *might* be fine, practically speaking, to
> assume that a collation with a matching iso-code and UCA version is
> compatible forever and always across any ICU version. If not, it might
> instead be feasible to write a custom fingerprinter for collation
> tailorings that ran at initdb time.

The documentation [0] states that the collation version covers a broad
range of things.  So I don't think these additional mechanisms you
describe are necessary.

[0]: http://userguide.icu-project.org/collation/architecture#TOC-Versioning

-- 
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