============================================================================ 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 ]