Thread: CREATE COLLATION to match pg_collation data
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.
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
On Sat, Jan 12, 2019 at 7:13 AM Tom Lane <tgl@sss.pgh.pa.us> 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