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@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.klaver@gmail.com