Skip site navigation (1) Skip section navigation (2)

Re: Setting locale

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 (view raw or flat)
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
>

In response to

pgsql-novice by date

Next:From: Tom WilcoxDate: 2010-06-22 16:52:46
Subject: Re: libpython - cannot open shared object file
Previous:From: Thom BrownDate: 2010-06-21 20:54:31
Subject: Re: Setting locale

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group