CREATE COLLATION to match pg_collation data

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

CREATE COLLATION to match pg_collation data

rihad

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



CREATE COLLATION name (
    [ LOCALE = locale, ]
    [ LC_COLLATE = lc_collate, ]
    [ LC_CTYPE = lc_ctype ]
)
CREATE COLLATION name FROM existing_collation

https://www.postgresql.org/docs/9.6/sql-createcollation.html


Can I just not use "create collation", and simply insert the new row as is?

Thanks for any tips.
Reply | Threaded
Open this post in threaded view
|

Re: CREATE COLLATION to match pg_collation data

Tom Lane-2
rihad <[hidden email]> 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

Reply | Threaded
Open this post in threaded view
|

Re: CREATE COLLATION to match pg_collation data

Peter Geoghegan-4
On Sat, Jan 12, 2019 at 7:13 AM Tom Lane <[hidden email]> wrote:
> That's an ICU collation, so you're out of luck: there is no ICU
> support in 9.6.

FWIW, there is some form of FreeBSD Postgres support for ICU that
predates the officially supported ICU feature. The FreeBSD Postgres
packages have been built with ICU support for many years -- they
modify the source code minimally to make this work. It may well still
be impossible to use "az-x-icu" on a FreeBSD installation of 9.6,
though.

--
Peter Geoghegan