Working the NLS stuff on win32. Considering I know very little about
this part (don't use it myself, never coded around in it), perhaps
someone else can shed some light?

PostgreSQL responds correctly to whatever the LC_MESSAGES environment
variable is set to upon startup of postgresql - I get my error messages
in swedish, english, german or whatever depending on that.

However, postgresql.conf does not load with the error message:
FATAL:  invalid value for parameter "lc_messages": "EN"

This goes for whatever I set lc_messages to, including all the
combinations that work when set in the environment variable. If I
comment it out completely from the config file, things appear to work
with the locale picked up from the environment.
(The error msg of course only shows up when NLS is enabled in configure)

Some quick tracking-down of this shows that the code on line 80-82 of

        save = setlocale(category, NULL);
        if (!save)
                return NULL;                    /* won't happen, we hope

*does* return NULL...

Now, I really don't know anything about the setlocale() integration, but
from the MSDN documentation
html/_crt_setlocale.2c_._wsetlocale.asp) doesn't even list LC_MESSAGES
as a valid identifier. My bet is that's why it returns NULL on

Also, some googling lead me to this:

Which appears to suggest that we should change the locale using putenv()
etc, and not using setlocale() at all... Because setlocale() does not
support LC_MESSAGES, probably.

Attached is a patch with adds a environment variable based version of
locale_messages_assign(). It's not a pretty solution, but I think it's
probably necessary.


(There is also a patch for initdb required to work on win32 when
compiled with NLS enabled, but this is the start...)


Attachment: win32nls.patch
Description: win32nls.patch

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
      joining column's datatypes do not match

Reply via email to