Thread: BUG #3397: change the pg_setting

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

Regards
Murali Doss T.S.

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

On Wed, Jun 20, 2007 at 12:51:57PM +0000, Murali Doss wrote:
> How to change the pg_setting from en_US.UTF-8 to "C".

You need to set up your locale before doing initdb.  This is covered
in the manual.  It's also not a bug, so it'd be nice if you stopped
posting this to the bugs list.  Use pgsql-novice instead, I think.

A

--
Andrew Sullivan  | ajs@crankycanuck.ca
Everything that happens in the world happens at some place.
        --Jane Jacobs