Re: NOTICE: pg_setlocale()

Hi,

On Wed, 14 Feb 2001 pgsql-bugs@postgresql.org wrote:

> fmatheus (fmatheus@ic.unicamp.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µ@-^ùž' 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