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
> >> 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
> >> 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
In response to
pgsql-novice by date
|Next:||From: Tom Wilcox||Date: 2010-06-22 16:52:46|
|Subject: Re: libpython - cannot open shared object file|
|Previous:||From: Thom Brown||Date: 2010-06-21 20:54:31|
|Subject: Re: Setting locale|