Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 05F0A9FB5DD for ; Wed, 25 Jul 2007 14:34:45 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 69377-01 for ; Wed, 25 Jul 2007 14:34:37 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 385FD9FBCA6 for ; Wed, 25 Jul 2007 14:34:37 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.1/8.14.1) with ESMTP id l6PHYClK028588; Wed, 25 Jul 2007 13:34:12 -0400 (EDT) To: "Martial Elise KIBA" cc: pgsql-admin@postgresql.org Subject: Re: Localisation In-reply-to: <20070725171632.M46418@mailer.gov.bf> References: <20070725171632.M46418@mailer.gov.bf> Comments: In-reply-to "Martial Elise KIBA" message dated "Wed, 25 Jul 2007 17:28:44 -0000" Date: Wed, 25 Jul 2007 13:34:12 -0400 Message-ID: <28587.1185384852@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200707/284 X-Sequence-Number: 26265 "Martial Elise KIBA" writes: > I have a postgresql sever running on RedHat EL 4.0 Update 2. > ... > But postgresql steal respond in english, and TO_CHAR(date, 'Day, DD Month > YYYY') return a date in english What PG version is this? Are you sure it was built with --enable-nls? ("pg_config --configure" is the way to check.) According to the manual, to_char() only emits localized month names if you use "TMMonth". But I'm not sure why you're not seeing localized messages, if the server was built with the correct options. regards, tom lane