============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================
Your name : David Jack Olrik
Your email address : [EMAIL PROTECTED]
System Configuration
---------------------
Architecture (example: Intel Pentium) : Intel Pentium II
Operating System (example: Linux 2.0.26 ELF) : Linux 2.2.14 ELF
PostgreSQL version (example: PostgreSQL-6.5.1): PostgreSQL-7.0beta3
Compiler used (example: gcc 2.8.0) : 2.95.2
Please enter a FULL description of your problem:
------------------------------------------------
LC_TIME is ignored.
select to_char('01/01/2000'::TIMESTAMP,'Day FMMonth');
yields:
to_char
-------------------
Saturday January
(1 row)
The name of the day and the name of the month should have been in the
language specified in LC_TIME
Please describe a way to repeat the problem. Please try to provide a
concise reproducible example, if at all possible:
----------------------------------------------------------------------
Compile with --enable-locale
export LC_COLLATE="da_DK"
export LC_CTYPE="da_DK"
export LC_TIME="da_DK" <- This is the most important one
Start postgres
use psql to do this query:
select to_char('01/01/2000'::TIMESTAMP,'Day FMMonth');
If you know how this problem might be fixed, list the solution below:
---------------------------------------------------------------------
N/A
--
Best regards,
David Jack Olrik <[EMAIL PROTECTED]> http://david.olrik.dk
[ Linux: Because rebooting is for adding new hardware ]