Skip site navigation (1) Skip section navigation (2)

Re: [pgsql-hackers-win32] Win32 & NLS

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Magnus Hagander" <mha(at)sollentuna(dot)net>
Cc: Peter Eisentraut <peter_e(at)gmx(dot)net>,"pgsql-patches" <pgsql-patches(at)postgresql(dot)org>
Subject: Re: [pgsql-hackers-win32] Win32 & NLS
Date: 2004-10-17 18:44:57
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackers-win32pgsql-patches
"Magnus Hagander" <mha(at)sollentuna(dot)net> 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

In response to

pgsql-patches by date

Next:From: Magnus HaganderDate: 2004-10-17 19:00:06
Subject: Re: [pgsql-hackers-win32] Win32 & NLS
Previous:From: Magnus HaganderDate: 2004-10-17 18:21:45
Subject: Re: Win32 & NLS

pgsql-hackers-win32 by date

Next:From: Marcus EngeneDate: 2004-10-17 19:07:41
Subject: Fetch of multiple rows using ecpg.
Previous:From: Magnus HaganderDate: 2004-10-17 18:21:45
Subject: Re: Win32 & NLS

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group