Re: BUG #3397: change the pg_setting

Murali Doss napsal(a):
> The following bug has been logged online:
> 
> Bug reference:      3397
> Logged by:          Murali Doss
> Email address:      murali.doss@mphasis.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