Locale settings - Mailing list pgsql-general

From Tille, Andreas
Subject Locale settings
Date
Msg-id Pine.LNX.4.44.0204221353170.5104-100000@wr-linux02.rki.ivbb.bund.de
Whole thread Raw
Responses Re: Locale settings
List pgsql-general
Hello,

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.

which where caused when I try

        to_char(temperatur, '999D9')

(By the way: It is not really important to get a ',' instead of the '.'
 but would be nice.  My most important concern is to get rid of this
 warning cleanly - which means not by switching of this warning level.)

Kind regards

         Andreas.

pgsql-general by date:

Previous
From: Peter Peltonen
Date:
Subject: Re: configure: error: header file is
Next
From: Jean-Michel POURE
Date:
Subject: Re: configure: error: header file is required for OpenSSL