Re: CREATE COLLATION to match pg_collation data - Mailing list pgsql-general

From Tom Lane
Subject Re: CREATE COLLATION to match pg_collation data
Date
Msg-id 30012.1547305988@sss.pgh.pa.us
Whole thread Raw
In response to CREATE COLLATION to match pg_collation data  (rihad <rihad@mail.ru>)
Responses Re: CREATE COLLATION to match pg_collation data
List pgsql-general
rihad <rihad@mail.ru> writes:
> Hi, since pg_import_system_collations() that would solve all this
> doesn't exist in 9.6.x, is there a way to I properly map it to a CREATE
> COLLATE call? Specifically I need to have this collation (from 10.x) in
> 9.6.x so it works on FreeBSD:

>          collname        | collnamespace | collowner | collprovider |
> collencoding |    collcollate    | collctype     | collversion
>
------------------------+---------------+-----------+--------------+--------------+-------------------+-------------------+-------------
>   az-x-icu               |            11 |        10 | i           
> |           -1 | az                | az                | 153.88.34

That's an ICU collation, so you're out of luck: there is no ICU
support in 9.6.

            regards, tom lane


pgsql-general by date:

Previous
From: Rich Shepard
Date:
Subject: Re: insert into: NULL in date column
Next
From: "David G. Johnston"
Date:
Subject: Re: insert into: NULL in date column