Re: CREATE COLLATION must be specified

2022-10-14 Thread Shay Rojansky
> > CREATE COLLATION some_collation (LC_COLLATE = 'en-u-ks-primary', > > LC_CTYPE = 'en-u-ks-primary', > > PROVIDER = icu, > > DETERMINISTIC = False > > ); > > > > This works on PG14, but on PG15 it errors with 'parameter "locale" must > > be specified'. > > > > I wanted to make sure

Re: CREATE COLLATION must be specified

2022-05-30 Thread jian he
--ok CREATE COLLATION some_collation ( PROVIDER = icu, LOCALE = 'en-u-ks-primary', DETERMINISTIC = FALSE ); CREATE COLLATION some_collation1 ( PROVIDER = icu, LC_COLLATE = 'en-u-ks-primary', LC_CTYPE = 'en-u-ks-primary', DETERMINISTIC = FALSE ); --ERROR: parameter "loca

Re: CREATE COLLATION must be specified

2022-05-28 Thread Peter Eisentraut
On 28.05.22 20:16, Shay Rojansky wrote: CREATE COLLATION some_collation (LC_COLLATE = 'en-u-ks-primary',     LC_CTYPE = 'en-u-ks-primary',     PROVIDER = icu,     DETERMINISTIC = False ); This works on PG14, but on PG15 it errors with 'parameter "locale" must be specified'. I wanted to mak