Palle Girgensohn's ICU patch
От | Jakob Egger |
---|---|
Тема | Palle Girgensohn's ICU patch |
Дата | |
Msg-id | 18C8A481-33A6-4483-8C24-B8CE70DB7F27@eggerapps.at обсуждение исходный текст |
Ответы |
Re: [pgsql-packagers] Palle Girgensohn's ICU patch
|
Список | pgsql-hackers |
When packaging PostgreSQL for Postgres.app, I discovered a problem: strcoll doesn't work for multibyte encodings on OS X.As a consequence, text sorting in PostgreSQL doesn't work. The only workaround seemed to be to use a legacy encoding likelatin1, which is inacceptable.<div class=""><br class="" /></div><div class="">I discovered that OS X shares this limitationwith FreeBSD, and there exists a patch written by Palle Girgensohn that uses the ICU library for collating stringsinstead of the std-c strcoll function. You can find it at <a class="" href="http://people.freebsd.org/~girgen/postgresql-icu/README.html">http://people.freebsd.org/~girgen/postgresql-icu/README.html</a></div><div class=""><brclass="" /></div><div class="">I applied the patch, and according to preliminary testing with 9.4rc1 it seemsto work flawlessly on OS X as well.</div><div class="">See <a class="" href="https://github.com/PostgresApp/PostgresApp/releases/tag/9.4rc1">https://github.com/PostgresApp/PostgresApp/releases/tag/9.4rc1</a></div><div class=""><brclass="" /></div><div class="">I have two questions:</div><div class=""><br class="" /></div><div class="">1)Does anybody else have experience with this patch? Is it safe to release PostgreSQL binaries with this patch appliedto the public?</div><div class=""><br class="" /></div><div class="">2) Is there a reason why this patch hasn't beenmerged into core over the years? Since it requires setting a configure switch (--with-icu) it shouldn't break anything?</div><divclass=""><br class="" /></div><div class="">Best regards,</div><div class="">Jakob Egger<br class="" /><divclass=""><br class="" /></div><div class=""><br class="" /></div></div>
В списке pgsql-hackers по дате отправления: