Re: insensitive collations

Peter Eisentraut <peter.eisentraut@2ndquadrant.com>

From: Peter Eisentraut <peter.eisentraut@2ndquadrant.com>

To: pgsql-hackers <pgsql-hackers@postgresql.org>

Date: 2018-12-28T08:55:49Z

Lists: pgsql-hackers

Attachments

v2-0001-Collations-with-nondeterministic-comparison.patch (text/plain) patch v2-0001

Here is an updated patch.

I have updated the naming to "deterministic", as discussed.

I have fixed up support for the "name" type, added foreign key support,
psql, pg_dump support, more tests.  There are a couple of TODOs in
bpchar support that I need to look into a bit more.  But other than that
it's pretty complete.

Perhaps it worth pointing out to new reviewers that the ICU tests can be
run like so:

    make check EXTRA_TESTS=collate.icu.utf8

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

Commits

Collations with nondeterministic comparison
- 5e1963fb764e 12.0 landed
Add support for collation attributes on older ICU versions
- b8f9a2a69a27 12.0 landed
Make type "name" collation-aware.
- 586b98fdf1aa 12.0 cited
Make collation-aware system catalog columns use "C" collation.
- 6b0faf723647 12.0 cited
Adjust string comparison so that only bitwise-equal strings are considered
- 656beff59033 8.2.0 cited