Re: Locale settings

"Tille, Andreas" <TilleA(at)rki(dot)de> writes:
> I've thought that I would have set my locale settings correctly for
> PostgreSQL 7.1.3. At least I have set my environment variables
> LANG=de_DE(at)euro
> LC_ALL=de_DE(at)euro
> Do I have to set additional LC_COLLATE and LC_CTYPE to avoid the
> following warnings

> Apr 22 12:22:13 wr-linux02 postgres[16149]: [2] NOTICE: pg_setlocale():
> 'LC_COLLATE=,@,@/locale' cannot be honored.
> Apr 22 12:22:13 wr-linux02 postgres[16149]: [3] NOTICE: pg_setlocale():
> 'LC_CTYPE=,@,@^P' cannot be honored.

You did not say what platform you are on, but I suspect you are getting
bit by 7.1's nonportable assumptions about behavior of localeconv().
These garbage locale strings could have come from 7.1's assumption that
a string returned by localeconv() will still be valid after changing
settings with setlocale().

Try 7.2.

regards, tom lane