From: | Cory Nemelka <cnemelka(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: Issues with inconsistent COLLATION installation |
Date: | 2019-09-09 18:45:22 |
Message-ID: | CAMe5Gn1gOdbr6PhquNFEcADo8LC8JegrUGD74pEkuGn2Mxn7kA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
We have already run pg_import_system_collations('pg_catalog')
--cnemelka
On Mon, Sep 9, 2019 at 12:43 PM Cory Nemelka <cnemelka(at)gmail(dot)com> wrote:
> We are having issues with some databases getting our locales generated.
> We are using Ubuntu 18.04 and postgresql 10.8.
>
> Example:
>
> *from bash prompt:*
>
> $ locale -a | egrep fr
> fr_BE
> fr_BE(at)euro
> fr_BE.iso88591
> fr_BE(dot)iso885915(at)euro
> fr_BE.utf8
> fr_CA
> fr_CA.iso88591
> fr_CA.utf8
> fr_CH
> fr_CH.iso88591
> fr_CH.utf8
> french
> fr_FR
> fr_FR(at)euro
> fr_FR.iso88591
> fr_FR(dot)iso885915(at)euro
> fr_FR.utf8
> fr_LU
> fr_LU(at)euro
> fr_LU.iso88591
> fr_LU(dot)iso885915(at)euro
> fr_LU.utf8
>
> *from psql prompt:*
>
> [local] cnemelka(at)postgres=# create collation french
> (provider=libc,locale='fr_FR.utf8');
> ERROR: 22023: could not create locale "fr_FR.utf8": No such file or
> directory
> DETAIL: The operating system could not find any locale data for the
> locale name "fr_FR.utf8".
> LOCATION: report_newlocale_failure, pg_locale.c:1312
>
> *Anyone having similar issues or know of the solution?*
>
> *TIA,*
> --cnemelka
>
From | Date | Subject | |
---|---|---|---|
Next Message | Cory Nemelka | 2019-09-09 20:08:04 | Re: Issues with inconsistent COLLATION installation |
Previous Message | Cory Nemelka | 2019-09-09 18:43:28 | Issues with inconsistent COLLATION installation |