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