Skip site navigation (1) Skip section navigation (2)

Re: BUG #3397: change the pg_setting

From: Zdenek Kotala <Zdenek(dot)Kotala(at)Sun(dot)COM>
To: Murali Doss <murali(dot)doss(at)mphasis(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #3397: change the pg_setting
Date: 2007-06-20 13:19:22
Message-ID: 4679295A.1080203@sun.com (view raw or flat)
Thread:
Lists: pgsql-bugs
Murali Doss napsal(a):
> The following bug has been logged online:
> 
> Bug reference:      3397
> Logged by:          Murali Doss
> Email address:      murali(dot)doss(at)mphasis(dot)com
> PostgreSQL version: 8.1.8
> Operating system:   Linux
> Description:        change the pg_setting
> Details: 
> 
> Dear All,
> 
> How to change the pg_setting from en_US.UTF-8 to "C".
> 
> lc_collate	- en_US.UTF-8
> lc_ctype	- en_US.UTF-8
> lc_messages	- en_US.UTF-8
> lc_monetary	- en_US.UTF-8
> lc_numeric	- en_US.UTF-8
> lc_time	- en_US.UTF-8
> 

Lc_collate and lc_ctype are possible setup only in initdb phase.
see initdb --help or 
http://www.postgresql.org/docs/8.2/interactive/app-initdb.html

More detail you can get on
http://www.postgresql.org/docs/8.2/interactive/locale.html

Please, this kind of question send to the general mailing list. This 
list is for bug reporting.

		Thanks Zdenek

In response to

pgsql-bugs by date

Next:From: Andrew SullivanDate: 2007-06-20 14:24:43
Subject: Re: BUG #3397: change the pg_setting
Previous:From: Murali DossDate: 2007-06-20 12:51:57
Subject: BUG #3397: change the pg_setting

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group