Re: Postgres 12: backend crashes when creating non-deterministic collation

2019-10-05 Thread Peter Eisentraut
On 2019-10-04 19:36, Tom Lane wrote: > Hm. This trace says that the crash happened somewhere down inside ICU > itself, during the ucol_open() call in get_collation_actual_version(). > There isn't much we could have done to mess up the arguments to that > function. That would seem to mean that it'

Re: Postgres 12: backend crashes when creating non-deterministic collation

2019-10-05 Thread Thomas Kellerer
Thomas Kellerer schrieb am 05.10.2019 um 13:39: Hm.  This trace says that the crash happened somewhere down inside ICU itself, during the ucol_open() call in get_collation_actual_version(). There isn't much we could have done to mess up the arguments to that function.  That would seem to mean tha

Re: Postgres 12: backend crashes when creating non-deterministic collation

2019-10-05 Thread Thomas Kellerer
Tom Lane schrieb am 04.10.2019 um 19:36: Hm. This trace says that the crash happened somewhere down inside ICU itself, during the ucol_open() call in get_collation_actual_version(). There isn't much we could have done to mess up the arguments to that function. That would seem to mean that it's

Re: Postgres 12: backend crashes when creating non-deterministic collation

2019-10-04 Thread Tom Lane
Thomas Kellerer writes: > Tom Lane schrieb am 04.10.2019 um 16:52: >> No, this thread is a sufficient report. What *would* be a good use >> of time is to get a stack trace from the crash, if you can. > I don't know if I did everything correctly, but here it is. I hope it helps >> icuuc53.dll!00

Re: Postgres 12: backend crashes when creating non-deterministic collation

2019-10-04 Thread Thomas Kellerer
Tom Lane schrieb am 04.10.2019 um 16:52: Is it worth the effort to report that through the bug reporting form? No, this thread is a sufficient report. What *would* be a good use of time is to get a stack trace from the crash, if you can. I don't know if I did everything correctly, but here i

Re: Postgres 12: backend crashes when creating non-deterministic collation

2019-10-04 Thread Thomas Kellerer
Daniel Verite schrieb am 04.10.2019 um 18:49: Creating works, but apparently on Windows ICU does not support this. After installing v12 on windows with the EDB installer, I notice that it ships with ICU 53, a relatively old version (2014). Concerning the problem just above (not the crash), ICU

Re: Postgres 12: backend crashes when creating non-deterministic collation

2019-10-04 Thread Daniel Verite
Thomas Kellerer wrote: > > To get a case insensitive collation you'd have to use something like > > > > LOCALE = 'de-DE-u-ks-level2' > > Creating works, but apparently on Windows ICU does not support this. After installing v12 on windows with the EDB installer, I notice that it ship

Re: Postgres 12: backend crashes when creating non-deterministic collation

2019-10-04 Thread Andres Freund
On 2019-10-04 10:52:38 -0400, Tom Lane wrote: > Thomas Kellerer writes: > > It also works on Windows when I specify "correct" locale names - the above > > seems to be an edge case. > > Is it worth the effort to report that through the bug reporting form? > > No, this thread is a sufficient repor

Re: Postgres 12: backend crashes when creating non-deterministic collation

2019-10-04 Thread Tom Lane
Thomas Kellerer writes: > It also works on Windows when I specify "correct" locale names - the above > seems to be an edge case. > Is it worth the effort to report that through the bug reporting form? No, this thread is a sufficient report. What *would* be a good use of time is to get a stack t

Re: Postgres 12: backend crashes when creating non-deterministic collation

2019-10-04 Thread Andreas Kretschmer
Am 04.10.19 um 12:13 schrieb Thomas Kellerer: I was trying to learn how the new non-deterministic collations in v12 work, but the following makes the backend crash: CREATE COLLATION de_ci (provider = icu, locale = 'de-x-icu', deterministic = false); Which leads to: 2019-10-04 11:54:23 CE

Re: Postgres 12: backend crashes when creating non-deterministic collation

2019-10-04 Thread Daniel Verite
Thomas Kellerer wrote: > It also works on Windows when I specify "correct" locale names - the above > seems to be an edge case. > Is it worth the effort to report that through the bug reporting form? Sure. Both the crash with 'de-x-icu' and the difference in behavior between Linux and Win

Re: Postgres 12: backend crashes when creating non-deterministic collation

2019-10-04 Thread Thomas Kellerer
Laurenz Albe schrieb am 04.10.2019 um 16:04: I was trying to learn how the new non-deterministic collations in v12 work, but the following makes the backend crash: CREATE COLLATION de_ci (provider = icu, locale = 'de-x-icu', deterministic = false); Which leads to: 2019-10-04 11:54:23 CEST LO

Re: Postgres 12: backend crashes when creating non-deterministic collation

2019-10-04 Thread Laurenz Albe
Thomas Kellerer wrote: > I was trying to learn how the new non-deterministic collations in v12 > work, but the following makes the backend crash: > > CREATE COLLATION de_ci (provider = icu, locale = 'de-x-icu', > deterministic = false); > > Which leads to: > > 2019-10-04 11:54:23 CEST LOG: se

Postgres 12: backend crashes when creating non-deterministic collation

2019-10-04 Thread Thomas Kellerer
I was trying to learn how the new non-deterministic collations in v12 work, but the following makes the backend crash: CREATE COLLATION de_ci (provider = icu, locale = 'de-x-icu', deterministic = false); Which leads to: 2019-10-04 11:54:23 CEST LOG: server process (PID 7540) was terminated