BUG #5818: initdb lose the single quote of locale

From: "yulei" <yu1ei(at)hotmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #5818: initdb lose the single quote of locale
Date: 2011-01-07 06:42:42
Message-ID: 201101070642.p076ggoG059006@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 5818
Logged by: yulei
Email address: yu1ei(at)hotmail(dot)com
PostgreSQL version: 9.0.2
Operating system: Windows XP Service Pack 3
Description: initdb lose the single quote of locale
Details:

Hi,dear developers!
I am using a chinses window xp os.
i run "initdb -E UTF-8 -D temp" in cmd,it can get the
locale:"Chinese_People's Republic of China.936"。

but when initdb creating template1 , it lose the single quote of locale,it
use "Chinese_Peoples Republic of China.936"(notice that , it lose the '
after "Chinese_People" ) for the "template1" record's
“datcollate”,“datctype” Column in tablepg_database。

though "creating template1 database" is ok,but the initdb's next step
"initializing pg_authid ..." failed.
bucause the invalid locale "Chinese_People's Republic of China.936" is used
to run the command "REVOKE ALL on pg_authid FROM public;"。

and the cmd resule is :
creating template1 database in temp/base/1 ... ok
initializing pg_authid ... : ݿʹõԻͲϵͳIJ
ϸϢ: ݿ⼯Ⱥ LC_COLLATE "Chinese_Peoples Re
ʾ: һԻ´ݿ⣬߰װʧԻ.
child process exited with exit code 1
initdb: removing data directory "temp"。

to support what i say , i test like:
add "
create pg_database_test 5158 ( datname = name )
open pg_database_test
insert OID = 1 ( "Chinese_People's Republic of China.936")
close pg_database_test
"
to postgreSQLHOME/share/postgres.bki

run cmd "initdb -E UTF-8 -D temp --local=chs"

it can init successful,then i start the server,run sql:
"SELECT * from pg_database_test" ,the result show "Chinese_Peoples Republic
of China.936".
yes ,the single quote of test string "Chinese_People's Republic of
China.936" lose.

can you fix it ?

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message yulei 2011-01-07 06:52:31 BUG #5819: Translation Error of initdb's zh_CN.po
Previous Message Gabe Nell 2011-01-07 05:52:48 Re: BUG #5807: psql fails to launch with "Cannot read termcap database; using dumb terminal settings. Aborted"