Murali Doss napsal(a):
The following bug has been logged online:
Bug reference: 3397
Logged by: Murali Doss
Email address: [EMAIL PROTECTED]
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
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
