Re: [HACKERS] NLS on MSVC strikes back!

2008-02-13 Thread Hiroshi Saito
Hi. Still, my health is not good... First, Probably, as for the 8.3 release binary, NLS is offed. Even if it arranges shar/locale, it is not used. Next, NLS was confirmed by VCBUILD of CVS-HEAD. A very interesting result can be seen here. http://inet.winpg.jp/~saito/pg_work/LC_MESSAGE_CHECK/

Re: [HACKERS] NLS on MSVC strikes back!

2008-02-12 Thread Hiroshi Saito
From: "Alvaro Herrera" <[EMAIL PROTECTED]> Dave Page wrote: On Feb 12, 2008 4:44 PM, Alvaro Herrera <[EMAIL PROTECTED]> wrote: > What this really means is that locale support is completely broken in > the MSVC build, i.e. you cannot get localized strings at all (not just > to_char()). Is this

Re: [HACKERS] NLS on MSVC strikes back!

2008-02-12 Thread Hiroshi Saito
Hi Alvaro-san. Yes, However, It is not in good condition at the reason a message catalog still is not enough. Then, I have tried these adjustments with the problem of a locale. Still, it is not much time. But, My condition is not good so that I'm may be influenza. :-( Regards, Hiroshi Saito

Re: [HACKERS] NLS on MSVC strikes back!

2008-02-12 Thread Gevik Babakhani
> What this really means is that locale support is completely > broken in the MSVC build, i.e. you cannot get localized > strings at all (not just to_char()). Is this correct? If > so, this is a serious problem. > The way one could confirm this is by: 1. rename share/locale/de to share/loca

Re: [HACKERS] NLS on MSVC strikes back!

2008-02-12 Thread Magnus Hagander
Alvaro Herrera wrote: Gevik Babakhani wrote: 4. Locale names are different in MS Windows. I created a C app to test gettext on Windows. setting LC_MESSAGES to Spanisg_Spain and German_Germany works but es_ES and de_DE do not :( SET LC_MESSAGES to '' has no effect because: A. gettext com

Re: [HACKERS] NLS on MSVC strikes back!

2008-02-12 Thread Alvaro Herrera
Dave Page wrote: > On Feb 12, 2008 4:44 PM, Alvaro Herrera <[EMAIL PROTECTED]> wrote: > > What this really means is that locale support is completely broken in > > the MSVC build, i.e. you cannot get localized strings at all (not just > > to_char()). Is this correct? If so, this is a serious prob

Re: [HACKERS] NLS on MSVC strikes back!

2008-02-12 Thread Dave Page
On Feb 12, 2008 4:44 PM, Alvaro Herrera <[EMAIL PROTECTED]> wrote: > What this really means is that locale support is completely broken in > the MSVC build, i.e. you cannot get localized strings at all (not just > to_char()). Is this correct? If so, this is a serious problem. Not judging by Hiro

Re: [HACKERS] NLS on MSVC strikes back!

2008-02-12 Thread Alvaro Herrera
Gevik Babakhani wrote: > 4. Locale names are different in MS Windows. I created a C app to test > gettext on Windows. > setting LC_MESSAGES to Spanisg_Spain and German_Germany works but es_ES and > de_DE do not :( > > SET LC_MESSAGES to '' has no effect because: > > A. gettext compiled/link

Re: [HACKERS] NLS on MSVC strikes back!

2008-02-12 Thread Gevik Babakhani
> to_char's month/day name localization is implemented with > gettext() not strftime(), which is why it depends on > LC_MESSAGES not LC_TIME. I seem to recall that we didn't > like the side-effects of the patch you are mentioning, and so > it ended up being rejected outright. Correct. I have

Re: [HACKERS] NLS on MSVC strikes back!

2008-02-12 Thread Alvaro Herrera
Hiroshi Saito wrote: > Hi > > --Document.-- > Table 9-22. > TM prefix translation mode (print localized day and month names based on > lc_messages) > -- > http://winpg.jp/~saito/pg_work/NLS_TO_CHAR_JP.png > But, Although Japanese is out of condition > > Does the fundamental specification chang

Re: [HACKERS] NLS on MSVC strikes back!

2008-02-12 Thread Tom Lane
Andrew Dunstan <[EMAIL PROTECTED]> writes: > On Nov 24 2006 this was committed dor src/backend/utils/adt/formatting.c: > r 1.114: Fix to_char() locale handling to honor LC_TIME, not LC_MESSAGES. > A few hours later it was supposedly reverted: r 1.115: Revert (too late > in beta): Fix to_char() l

Re: [HACKERS] NLS on MSVC strikes back!

2008-02-12 Thread Bruce Momjian
Andrew Dunstan wrote: > > > Alvaro Herrera wrote: > > Gevik Babakhani wrote: > > > >> I have compiled 8.3 (CVS HEAD) with NLS on a XP box. But it seems that NLS > >> support is broke. > >> Could someone please confirm this. > >> > > > > What I can confirm is that lc_messages is supposed t

Re: [HACKERS] NLS on MSVC strikes back!

2008-02-12 Thread Hiroshi Saito
Hi --Document.-- Table 9-22. TM prefix translation mode (print localized day and month names based on lc_messages) -- http://winpg.jp/~saito/pg_work/NLS_TO_CHAR_JP.png But, Although Japanese is out of condition Does the fundamental specification change? Regards, Hiroshi Saito - Origin

Re: [HACKERS] NLS on MSVC strikes back!

2008-02-12 Thread Andrew Dunstan
Alvaro Herrera wrote: Gevik Babakhani wrote: I have compiled 8.3 (CVS HEAD) with NLS on a XP box. But it seems that NLS support is broke. Could someone please confirm this. What I can confirm is that lc_messages is supposed to work for to_char, because it shows the localized output f

Re: [HACKERS] NLS on MSVC strikes back!

2008-02-12 Thread Alvaro Herrera
Gevik Babakhani wrote: > I have compiled 8.3 (CVS HEAD) with NLS on a XP box. But it seems that NLS > support is broke. > Could someone please confirm this. What I can confirm is that lc_messages is supposed to work for to_char, because it shows the localized output for me as I change lc_messages;

Re: [HACKERS] NLS on MSVC strikes back!

2008-02-12 Thread Gevik Babakhani
> Right, I know that. But I didn't see you trying lc_time as > Andrew suggested. > Did that too, but no luck :( ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

Re: [HACKERS] NLS on MSVC strikes back!

2008-02-12 Thread Andrew Dunstan
Gevik Babakhani wrote: Well, that should be considered a bug, not a feature. Perhaps it was fixed in 8.3. This is 8.3 I am testing with. You are missing Alvaro's point. He is saying that the behaviour you relied on in 8.2.6 was a bug, and possibly you can no longer rely on th

Re: [HACKERS] NLS on MSVC strikes back!

2008-02-12 Thread Alvaro Herrera
Gevik Babakhani wrote: > > Well, that should be considered a bug, not a feature. > > Perhaps it was fixed in 8.3. > > This is 8.3 I am testing with. Right, I know that. But I didn't see you trying lc_time as Andrew suggested. -- Alvaro Herrerahttp://www.Comman

Re: [HACKERS] NLS on MSVC strikes back!

2008-02-12 Thread Gevik Babakhani
> Well, that should be considered a bug, not a feature. > Perhaps it was fixed in 8.3. > This is 8.3 I am testing with. ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [HACKERS] NLS on MSVC strikes back!

2008-02-12 Thread Alvaro Herrera
Gevik Babakhani wrote: > > Should that not be lc_time you are setting? lc_messages is > > for, uh, messages. > > No. The same thing works on 8.2.6 Well, that should be considered a bug, not a feature. Perhaps it was fixed in 8.3. -- Alvaro Herrerahttp://www.Com

Re: [HACKERS] NLS on MSVC strikes back!

2008-02-12 Thread Gevik Babakhani
> Should that not be lc_time you are setting? lc_messages is > for, uh, messages. No. The same thing works on 8.2.6 ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [HACKERS] NLS on MSVC strikes back!

2008-02-12 Thread Andrew Dunstan
Gevik Babakhani wrote: I have compiled 8.3 (CVS HEAD) with NLS on a XP box. But it seems that NLS support is broke. Could someone please confirm this. My test: Gevik=# Gevik=# set lc_messages TO 'de_DE.utf8'; SET Gevik=# show lc_messages ; lc_messages - de_DE.utf8 (1 row) Gevi

[HACKERS] NLS on MSVC strikes back!

2008-02-12 Thread Gevik Babakhani
I have compiled 8.3 (CVS HEAD) with NLS on a XP box. But it seems that NLS support is broke. Could someone please confirm this. My test: Gevik=# Gevik=# show lc_messages ; lc_messages English_United States.1252 (1 row) Gevik=# Gevik=# set lc_messages TO 'de_