pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Localisation
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