"Magnus Hagander" <[EMAIL PROTECTED]> writes: > Tried that too. Tried a whole lot of combinations of both unix style > (sv_SE, sv, se, se_sv for example) and windows style (Swedish.Sweden, > Sweden.Swedish, Swedish.Sweden.1252, etc etc). *it never works*. It > *does work* if I set it as an environment variable.
I tried setting a breakpoint at setlocale() and tracing through postmaster startup. I now realize that we have a rather fundamental problem, which is that the startup sequence is essentially: setlocale(LC_COLLATE, ""); setlocale(LC_CTYPE, ""); // other uninteresting setlocales... setlocale(LC_MESSAGES, value_from_config_file); // and ditto for the other LC values in the config file setlocale(LC_COLLATE, value_from_pg_control); setlocale(LC_CTYPE, value_from_pg_control); That is, postgresql.conf is read before we have located and read pg_control. Therefore, if the LC_CTYPE value specified in pg_control is different from whatever happens to be implied by the postmaster's current environment, it is entirely possible for the set of allowed LC_MESSAGES values during the initial config file read to be different from the set that would be legal later. I am supposing here that setlocale() may reject LC_MESSAGES values that imply a character set different from that implied by LC_CTYPE. Magnus, can you try a quick standalone test program to see if Windows' setlocale seems to act that way? The FAQ you pointed at implies that GNU gettext has some issues in this area, but it doesn't say outright that the setlocale function itself fails. If this is the problem then it might explain the various past complaints we've gotten about being unable to set LC_MESSAGES on some operating systems (OS X at least). My thoughts about fixing it are leaning towards postponing processing of the LC_xxx config values until after we've read pg_control, but that seems like a mess :-( regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org