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

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