"Tille, Andreas" <TilleA@rki.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@euro
> LC_ALL=de_DE@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