Re: BUG #1583: Locale problem - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #1583: Locale problem
Date
Msg-id 2338.1112733115@sss.pgh.pa.us
Whole thread Raw
In response to BUG #1583: Locale problem  ("Andrew Grillet" <andrew@grillet.co.uk>)
List pgsql-bugs
"Andrew Grillet" <andrew@grillet.co.uk> writes:
> error message XX000: cannot assign "" to LC_messages - or something like
> this.

We've seen this before but AFAIR no one has ever really satisfactorily
explained what's happening.  Assigning an empty string *should* work;
the definition of setlocale is that it's supposed to select the default
locale.  It's difficult to believe that selecting the default locale
does not work.

If you check the archives you will definitely find this mentioned in
connection with Mac OS X.  Not sure if we've heard it before for FreeBSD
or not.  What FreeBSD release have you got exactly, and what locale
environment were you starting the postmaster in?  Did you have
nondefault values for any of the other LC_xxx settings?

> (I dont really want locale support
> anyway, I just want European dates.)

In that case you should stick with C locale and just set DateStyle.
But if you'd like to help track down this locale failure first ...

            regards, tom lane

pgsql-bugs by date:

Previous
From: "Andrew Grillet"
Date:
Subject: BUG #1583: Locale problem
Next
From: Mehul Doshi-A20614
Date:
Subject: 8.0.1 Installation Error in Windows XP