Re: Solve a problem of LC_TIME of windows.

From: ITAGAKI Takahiro <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>
To: Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp>
Cc: Hiroshi Saito <z-saito(at)guitar(dot)ocn(dot)ne(dot)jp>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Solve a problem of LC_TIME of windows.
Date: 2009-01-07 05:09:22
Message-ID: 20090107140111.810A.52131E4D@oss.ntt.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches


Hiroshi Inoue <inoue(at)tpf(dot)co(dot)jp> wrote:

> Seems LC_CTYPE and LC_TIME should be convertible even though we use
> wcsftime (which internally calls strftime?).

Ok, wcsftime() requries both LC_TIME and LC_CTYPE are the same setting
(at least encoding) on Windows.

The attached patch is an updated version to fix cache_locale_time().
Now it sets LC_TIME and LC_CTYPE to the specified locale and restore
them at end of the function. I tested the patch on Windows XP Japanese
Edition (SJIS) with UTF-8 and EUCJP databases, and worked expectedly.

"#ifdef WIN32" codes seems to be ugly in the patch,
but I have no other idea...

Regards,
---
ITAGAKI Takahiro
NTT Open Source Software Center

Attachment Content-Type Size
pg_locale-2009-01-07.diff application/octet-stream 2.6 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2009-01-07 05:15:48 Do we still need constraint_exclusion?
Previous Message Robert Haas 2009-01-07 04:49:57 Re: Proposed Patch to Improve Performance of Multi-BatchHash Join for Skewed Data Sets

Browse pgsql-patches by date

  From Date Subject
Next Message Alvaro Herrera 2009-01-07 13:22:52 Re: Solve a problem of LC_TIME of windows.
Previous Message Devrim GÜNDÜZ 2009-01-06 17:19:59 Re: Fwd: [PATCHES] Auto Partitioning Patch - WIP version 1