| 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: | Whole Thread | Raw Message | 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
| 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 |