Re: [GENERAL] (collation) Building postgresql on FreeBSD, the pros and cons of icu

2013-10-25 Thread Achilleas Mantzios
On 23/10/2013 16:44, Tom Lane wrote: Patrick Dung patrick_...@yahoo.com.hk writes: By default, FreeBSD ports does not build postgresql with icu (http://www.icu-project.org/). Postgres does not have any option to use ICU, default or otherwise. Nor is it likely to happen in future, judging from

Re: [GENERAL] (collation) Building postgresql on FreeBSD, the pros and cons of icu

2013-10-25 Thread Patrick Dung
On Wednesday, October 23, 2013 10:00 PM, Patrick Dung patrick_...@yahoo.com.hk wrote: On Wednesday, October 23, 2013 9:45 PM, Tom Lane t...@sss.pgh.pa.us wrote: Patrick Dung patrick_...@yahoo.com.hk writes:   By default, FreeBSD ports does not build postgresql with icu

Re: [GENERAL] (collation) Building postgresql on FreeBSD, the pros and cons of icu

2013-10-25 Thread Patrick Dung
On Friday, October 25, 2013 3:12 PM, Achilleas Mantzios ach...@matrix.gatewaynet.com wrote: On 23/10/2013 16:44, Tom Lane wrote: Patrick Dung patrick_...@yahoo.com.hk writes: By default, FreeBSD ports does not build postgresql with icu (http://www.icu-project.org/). Postgres does not have

[GENERAL] (collation) Building postgresql on FreeBSD, the pros and cons of icu

2013-10-23 Thread Patrick Dung
Hi all, By default, FreeBSD ports does not build postgresql with icu (http://www.icu-project.org/). Some questions: 1) It is necessary that icu should be used on FreeBSD? I have heard that FreeBSD's locale (glibc) has sorting problem with Postgresql UTF8 DB. reference:

Re: [GENERAL] (collation) Building postgresql on FreeBSD, the pros and cons of icu

2013-10-23 Thread Tom Lane
Patrick Dung patrick_...@yahoo.com.hk writes: By default, FreeBSD ports does not build postgresql with icu (http://www.icu-project.org/). Postgres does not have any option to use ICU, default or otherwise. Nor is it likely to happen in future, judging from previous discussions of the idea.

Re: [GENERAL] (collation) Building postgresql on FreeBSD, the pros and cons of icu

2013-10-23 Thread Patrick Dung
On Wednesday, October 23, 2013 9:45 PM, Tom Lane t...@sss.pgh.pa.us wrote: Patrick Dung patrick_...@yahoo.com.hk writes:   By default, FreeBSD ports does not build postgresql with icu (http://www.icu-project.org/ ). Postgres does not have any option to use ICU, default or otherwise. Nor