lc_time not working? - Mailing list pgsql-general

From J. Hondius
Subject lc_time not working?
Date
Msg-id 50EADF85.6030503@rem.nl
Whole thread Raw
Responses Re: lc_time not working?  (Adrian Klaver <adrian.klaver@gmail.com>)
List pgsql-general
Hi All,
please advise

I'm not getting my PostgreSQL 9.2 to return the correct lc_time
See psql output below.
lc_monetary and the lc's do work correctly

postgresql.conf is set to lc_time = 'nl_NL'
the output of locale -a includes nl_NL

[root@d01 ~]# psql db user
psql (9.2.1)
Type "help" for help.

openwave001=# select set_config('lc_time', 'nl_NL', true);
 set_config
------------
 nl_NL
(1 row)

openwave001=# select to_char(now(),'dd month day yyyy');
           to_char
-----------------------------
 07 january   monday    2013
(1 row)



pgsql-general by date:

Previous
From: kenyon
Date:
Subject: currval of sequence xxx_seq is not yet defined in this session?
Next
From: Adrian Klaver
Date:
Subject: Re: lc_time not working?