Thread: Adding new collations after pg_upgrade?
Hi. on a freshly installed 10.6 I can see all ICU collations added in pg_collation schema. Is there a way to have them for an existing database cluster?
rihad <rihad@mail.ru> writes: > Hi. on a freshly installed 10.6 I can see all ICU collations added in > pg_collation schema. Is there a way to have them for an existing > database cluster? There's a function called something like pg_import_system_collations. See documentation. regards, tom lane
On 01/06/2019 07:51 PM, Tom Lane wrote: > rihad <rihad@mail.ru> writes: >> Hi. on a freshly installed 10.6 I can see all ICU collations added in >> pg_collation schema. Is there a way to have them for an existing >> database cluster? > There's a function called something like pg_import_system_collations. > See documentation. Thanks a lot! postgres=# select pg_import_system_collations('pg_catalog'); pg_import_system_collations ----------------------------- 798 (1 row) postgres=# select pg_import_system_collations('pg_catalog'); pg_import_system_collations ----------------------------- 0 (1 row) > > regards, tom lane > . >
On 01/06/2019 07:57 PM, rihad wrote: > On 01/06/2019 07:51 PM, Tom Lane wrote: >> rihad <rihad@mail.ru> writes: >>> Hi. on a freshly installed 10.6 I can see all ICU collations added in >>> pg_collation schema. Is there a way to have them for an existing >>> database cluster? >> There's a function called something like pg_import_system_collations. >> See documentation. > > Thanks a lot! > > postgres=# select pg_import_system_collations('pg_catalog'); > pg_import_system_collations > ----------------------------- > 798 > (1 row) > > postgres=# select pg_import_system_collations('pg_catalog'); > pg_import_system_collations > ----------------------------- > 0 > (1 row) Oops, I meant schema pg_collation ) > > >> >> regards, tom lane >> . >> >
On 01/06/2019 08:05 PM, rihad wrote: > On 01/06/2019 07:57 PM, rihad wrote: >> On 01/06/2019 07:51 PM, Tom Lane wrote: >>> rihad <rihad@mail.ru> writes: >>>> Hi. on a freshly installed 10.6 I can see all ICU collations added in >>>> pg_collation schema. Is there a way to have them for an existing >>>> database cluster? >>> There's a function called something like pg_import_system_collations. >>> See documentation. >> >> Thanks a lot! >> >> postgres=# select pg_import_system_collations('pg_catalog'); >> pg_import_system_collations >> ----------------------------- >> 798 >> (1 row) >> >> postgres=# select pg_import_system_collations('pg_catalog'); >> pg_import_system_collations >> ----------------------------- >> 0 >> (1 row) > > Oops, I meant schema pg_collation ) Phew, sorry for my confusion. Schema pg_catalog. Table pg_collation. So I did it right ) >> >> >>> >>> regards, tom lane >>> . >>> >> >