From: | Laslo Forro <getforum(at)gmail(dot)com> |
---|---|
To: | Thom Brown <thombrown(at)gmail(dot)com> |
Cc: | pgsql-novice(at)postgresql(dot)org |
Subject: | Re: Setting locale |
Date: | 2010-06-22 08:42:34 |
Message-ID: | AANLkTilmIzUgmftsLO_cKOWUGLWorl3QqH-Trv5HCMep@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Does it mean that I have to initdb postgresql with the locale settings?
On Mon, Jun 21, 2010 at 10:54 PM, Thom Brown <thombrown(at)gmail(dot)com> wrote:
> 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 | Tom Wilcox | 2010-06-22 16:52:46 | Re: libpython - cannot open shared object file |
Previous Message | Thom Brown | 2010-06-21 20:54:31 | Re: Setting locale |