Re: ts_parse reports different between MacOS, FreeBSD/Linux - Mailing list pgsql-general

From Tom Lane
Subject Re: ts_parse reports different between MacOS, FreeBSD/Linux
Date
Msg-id 625396.1608662804@sss.pgh.pa.us
Whole thread Raw
In response to ts_parse reports different between MacOS, FreeBSD/Linux  ("Mark Felder" <feld@FreeBSD.org>)
List pgsql-general
"Mark Felder" <feld@FreeBSD.org> writes:
> We have an application whose test suite fails on MacOS when running the search tests on unicode characters.

Yeah, known problem :-(.  The text search parser relies on the C library's
locale data to classify characters as being letters, digits, etc.
Unfortunately, the UTF8 locales on macOS are just horribly bad, and
report many results that are different from other platforms.

I suppose that Apple has got reasonable Unicode character knowledge
somewhere in their OS; they are just not very interested in making the
POSIX locale APIs work well.  Which leaves us with a bit of a problem
for getting consistent results cross-platform.

            regards, tom lane



pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Missing rows after migrating from postgres 11 to 12 with logical replication
Next
From: Adrian Klaver
Date:
Subject: Information schema sql_identifier