Re: NOTICE: pg_setlocale()

Hi,

On Wed, 14 Feb 2001 pgsql-bugs(at)postgresql(dot)org wrote:

> fmatheus (fmatheus(at)ic(dot)unicamp(dot)br) reports a bug with a severity of 3
> The lower the number the more severe it is.
>
> Short Description
> NOTICE: pg_setlocale()
>
> Long Description
> Im a Debian user of postgresql version 7.0.3-4.
> libc6 and locales 2.2-6. (LANG=pt_BR, but problem stay with en_US)
> that is a unstable package so maybe that is fault of libc6.
>
>
>
> Sample Code
> SELECT to_char(2.4, 'L9990D99');
> NOTICE: pg_setlocale(): 'LC_CTYPE= @x' cannot be honored.
> NOTICE: pg_setlocale(): 'LC_COLLATE=ð~µ' cannot be honored..
> NOTICE: pg_setlocale(): 'LC_MONETARY=xµ(at)-^ùž' cannot be honored.d.
> to_char
> ------------
> R$ 2,40

We also had that problem here at SuSE. The glibc people told me that
it is a bug in the current glibc which will be fixed in the next
version.

As a workarround you can try to unset LANG and all LC_* variables.

cu
Reinhard