From: | Thom Brown <thombrown(at)gmail(dot)com> |
---|---|
To: | Laslo Forro <getforum(at)gmail(dot)com> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: Setting locale |
Date: | 2010-06-21 20:54:31 |
Message-ID: | AANLkTilA8tJvrbPTTjXIbMeRdJr_jGcN0YNUmqU7KwHq@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
On 21 June 2010 21:51, Thom Brown <thombrown(at)gmail(dot)com> wrote:
> On 21 June 2010 21:28, Laslo Forro <getforum(at)gmail(dot)com> wrote:
>> Hi there,
>> I am trying to set the --locale for a database but receive 'invalid locale
>> name'
>> Here is the posgresql.conf part:
>> lc_messages = 'en_US.UTF-8' # locale for system error message
>> # strings
>> lc_monetary = 'en_US.UTF-8' # locale for monetary formatting
>> lc_numeric = 'en_US.UTF-8' # locale for number formatting
>> lc_time = 'en_US.UTF-8' # locale for time formatting
>> default_text_search_config = 'pg_catalog.english'
>> locale -a says:
>> C
>> en_US.utf8
>> hu_HU.utf8
>> POSIX
>> I would like to use hu_HU.utf8:
>> createdb -E UTF8 --locale='hu_HU.utf8' test
>> Password:
>> createdb: database creation failed: ERROR: invalid locale name hu_HU.utf8
>> Postgresql is on Debian. Default locale is en_US.utf8
>> Any idea is appreciated.
>
> What do you get with: locale -a | grep hr_HR
>
> Thom
>
Erk... no, my mistake. Ignore my last message.
In any case, shouldn't it be: createdb -E utf8 --locale='hu_HU' test
Thom
From | Date | Subject | |
---|---|---|---|
Next Message | Laslo Forro | 2010-06-22 08:42:34 | Re: Setting locale |
Previous Message | Thom Brown | 2010-06-21 20:51:54 | Re: Setting locale |