Re: ts_parse reports different between MacOS, FreeBSD/Linux

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: ts_parse reports different between MacOS, FreeBSD/Linux
Дата
Msg-id 625396.1608662804@sss.pgh.pa.us
обсуждение исходный текст
Ответ на ts_parse reports different between MacOS, FreeBSD/Linux  ("Mark Felder" <feld@FreeBSD.org>)
Список 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 по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: Missing rows after migrating from postgres 11 to 12 with logical replication
Следующее
От: Adrian Klaver
Дата:
Сообщение: Information schema sql_identifier