Re: postgresql: libc collation issue, linking with ICU

2019-12-12 Thread f.holop
Jeremie Courreges-Anglas - Thu, 12 December 2019 at 11:35:51 > Can you actually use ICU as the default collation algorithm used by > a database? it's not totally straightforward but yes, on the schema level it's possible to override collation: macos=# CREATE TABLE t (n text COLLATE

Re: postgresql: libc collation issue, linking with ICU

2019-12-12 Thread Jeremie Courreges-Anglas
On Thu, Dec 12 2019, "f.holop" wrote: > Landry Breuil - Thu, 12 December 2019 at 08:51:49 >> On Thu, Dec 12, 2019 at 01:47:25AM +0100, Jeremie Courreges-Anglas wrote: >> > >> > +cc maintainer >> > >> > This has bugged me for some time, I think enabling ICU makes sense. >> > Here's a wip diff.

Re: postgresql: libc collation issue, linking with ICU

2019-12-12 Thread f.holop
Landry Breuil - Thu, 12 December 2019 at 08:51:49 > On Thu, Dec 12, 2019 at 01:47:25AM +0100, Jeremie Courreges-Anglas wrote: > > > > +cc maintainer > > > > This has bugged me for some time, I think enabling ICU makes sense. > > Here's a wip diff. I fear it might cause issues with existing > >

Re: postgresql: libc collation issue, linking with ICU

2019-12-11 Thread Landry Breuil
On Thu, Dec 12, 2019 at 01:47:25AM +0100, Jeremie Courreges-Anglas wrote: > > +cc maintainer > > This has bugged me for some time, I think enabling ICU makes sense. > Here's a wip diff. I fear it might cause issues with existing > databases. Real world tests would probably help. I doubt it

Re: postgresql: libc collation issue, linking with ICU

2019-12-11 Thread Jeremy Evans
On Wed, Dec 11, 2019 at 4:50 PM Jeremie Courreges-Anglas wrote: > > +cc maintainer > > This has bugged me for some time, I think enabling ICU makes sense. > Here's a wip diff. I fear it might cause issues with existing > databases. Real world tests would probably help. > I would prefer that

Re: postgresql: libc collation issue, linking with ICU

2019-12-11 Thread Jeremie Courreges-Anglas
+cc maintainer This has bugged me for some time, I think enabling ICU makes sense. Here's a wip diff. I fear it might cause issues with existing databases. Real world tests would probably help. FWIW I would also like to enable DEBUG_PACKAGES and investigate whether --disable-thread-safety

Re: postgresql: libc collation issue, linking with ICU

2019-12-11 Thread f.holop
Ingo Schwarze - Wed, 11 December 2019 at 20:46:05 > Hi, > > Stuart Henderson wrote on Wed, Dec 11, 2019 at 07:19:16PM +: > > On 2019/12/11 19:57, f.holop wrote: > >> Ingo Schwarze - Wed, 11 December 2019 at 18:42:35 > > i have noticed that libc collation on OpenBSD is broken (also on

Re: postgresql: libc collation issue, linking with ICU

2019-12-11 Thread Ingo Schwarze
Hi, Stuart Henderson wrote on Wed, Dec 11, 2019 at 07:19:16PM +: > On 2019/12/11 19:57, f.holop wrote: >> Ingo Schwarze - Wed, 11 December 2019 at 18:42:35 i have noticed that libc collation on OpenBSD is broken (also on macos) :( >>> It is intentional that OpenBSD does not support

Re: postgresql: libc collation issue, linking with ICU

2019-12-11 Thread Stuart Henderson
On 2019/12/11 19:57, f.holop wrote: > Ingo Schwarze - Wed, 11 December 2019 at 18:42:35 > > > i have noticed that libc collation on OpenBSD is broken (also on macos) :( > > > > It is intentional that OpenBSD does not support collation for locales > > other than "C" in libc, and i'm not aware of

Re: postgresql: libc collation issue, linking with ICU

2019-12-11 Thread f.holop
Ingo Schwarze - Wed, 11 December 2019 at 18:42:35 > > i have noticed that libc collation on OpenBSD is broken (also on macos) :( > > It is intentional that OpenBSD does not support collation for locales > other than "C" in libc, and i'm not aware of any developer who might > have plans to add it

Re: postgresql: libc collation issue, linking with ICU

2019-12-11 Thread Ingo Schwarze
Hi, f.holop wrote on Tue, Dec 10, 2019 at 05:07:07PM +0100: > i have noticed that libc collation on OpenBSD is broken (also on macos) :( It is intentional that OpenBSD does not support collation for locales other than "C" in libc, and i'm not aware of any developer who might have plans to add

postgresql: libc collation issue, linking with ICU

2019-12-10 Thread f.holop
hello, i have noticed that libc collation on OpenBSD is broken (also on macos) :( openbsd=# select n from (values ('bernard'),('bérénice'),('béatrice'),('boris')) AS l(n) order by n collate "fr_FR" n -- bernard boris béatrice bérénice (4 rows) macos=# select n from (values