Re: CREATE COLLATION to match pg_collation data

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: rihad <rihad(at)mail(dot)ru>
Cc: pgsql-general General <pgsql-general(at)postgresql(dot)org>
Subject: Re: CREATE COLLATION to match pg_collation data
Date: 2019-01-12 15:13:08
Message-ID: 30012.1547305988@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

rihad <rihad(at)mail(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David G. Johnston 2019-01-12 15:53:35 Re: insert into: NULL in date column
Previous Message Rich Shepard 2019-01-12 13:43:00 Re: insert into: NULL in date column