[BUGS] BUG #1583: Locale problem
The following bug has been logged online: Bug reference: 1583 Logged by: Andrew Grillet Email address: [EMAIL PROTECTED] PostgreSQL version: 7.4.7 Operating system: FreeBSD 5.3 Description:Locale problem Details: error message XX000: cannot assign "" to LC_messages - or something like this. The cause appears to be that line 1414 of guc.c has a null string in place of "C", at any rate, when I changed "" to "C" the problem went away. The error message was not very helpful, and there might be some way to work around this, but I couldn't find it. The work-arounds suggested by Linux people did not seem to work on FreeBSD. The locale documentation in the manual suggests that all locales listed by "locale -a" will work. I could not get en_GB or en or en_GB.ISO5589.1 to work, but all are listed by locale -a. (I dont really want locale support anyway, I just want European dates.) ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [BUGS] BUG #1583: Locale problem
"Andrew Grillet" <[EMAIL PROTECTED]> 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 ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings
