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

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 ?

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

On 07.01.2011 08:42, yulei 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。

Fixed. Thanks for the report, and sorry for the delay. The fix will
appear in the next minor version.

--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com