pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedLocalisation
2+ messages / 2 participants
[nested] [flat]
* Localisation
@ 2007-07-25 17:28 Martial Elise KIBA <mkiba@delgi.gov.bf>
0 siblings, 1 reply; 2+ messages in thread
From: Martial Elise KIBA @ 2007-07-25 17:28 UTC (permalink / raw)
To: pgsql-admin
Hi all!
I have a postgresql sever running on RedHat EL 4.0 Update 2.
the following locales applies to my database:
lc_messages = 'fr_FR.UTF-8' # locale for system error message
# strings
lc_monetary = 'fr_FR.UTF-8' # locale for monetary formatting
lc_numeric = 'fr_FR.UTF-8' # locale for number formatting
lc_time = 'fr_FR.UTF-8' # locale for time formatting
But postgresql steal respond in english, and TO_CHAR(date, 'Day, DD Month
YYYY') return a date in english
Martial E. W. KIBA
Ingénieur de Conception en Informatiques
Option Génie-Logiciel
Tél: (+226) 70 15 44 93
Mail: mkiba@delgi.gov.bf / mkiba01@yahoo.fr
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Localisation
@ 2007-07-25 17:34 Tom Lane <tgl@sss.pgh.pa.us>
parent: Martial Elise KIBA <mkiba@delgi.gov.bf>
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 2007-07-25 17:34 UTC (permalink / raw)
To: Martial Elise KIBA <mkiba@delgi.gov.bf>; +Cc: pgsql-admin
"Martial Elise KIBA" <mkiba@delgi.gov.bf> 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
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2007-07-25 17:34 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-07-25 17:28 Localisation Martial Elise KIBA <mkiba@delgi.gov.bf>
2007-07-25 17:34 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox