Re: BUG #5818: initdb lose the single quote of locale

On Fri, Jan 7, 2011 at 1:42 AM, yulei <yu1ei(at)hotmail(dot)com> wrote:
>
> 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 ?

I don't see any responses to this bug. Do we have a quoting problem somewhere?

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company