Re: BUG #3397: change the pg_setting - Mailing list pgsql-bugs

From Zdenek Kotala
Subject Re: BUG #3397: change the pg_setting
Date
Msg-id 4679295A.1080203@sun.com
Whole thread Raw
In response to BUG #3397: change the pg_setting  ("Murali Doss" <murali.doss@mphasis.com>)
List pgsql-bugs
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

pgsql-bugs by date:

Previous
From: "Murali Doss"
Date:
Subject: BUG #3397: change the pg_setting
Next
From: "Murali Doss"
Date:
Subject: Re: BUG #3394: Partial search not working