Re: lc_time not working?

On 01/07/2013 06:45 AM, J. Hondius wrote:
> 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(at)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)

When you use true it only applies for that transaction.

Example:

test=# select set_config('lc_time', 'nl_NL', True);
set_config
------------
nl_NL
(1 row)

test=# SELECT current_setting('lc_time');
current_setting
-----------------
en_US.UTF-8
(1 row)

When you false it sticks for the session:

test=# select set_config('lc_time', 'nl_NL', False);
set_config
------------
nl_NL
(1 row)

test=# SELECT current_setting('lc_time');
current_setting
-----------------
nl_NL

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

--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com