Can't create 8.4 database when specifying collation and character type in 1.10 beta
От | Obe, Regina |
---|---|
Тема | Can't create 8.4 database when specifying collation and character type in 1.10 beta |
Дата | |
Msg-id | 53F9CF533E1AA14EA1F8C5C08ABC08D204D7F299@ZDND.DND.boston.cob обсуждение исходный текст |
Ответы |
Re: Can't create 8.4 database when specifying
collation and character type in 1.10 beta
|
Список | pgadmin-support |
<p><font size="2">I'm using 1.10.0 beta 2 -- the one that comes with EnterpriseDB 8.4 beta1.<br /><br /> When I try to createa new database and specify the collations and character type I get error something to the effect syntax error in collate.<br/><br /> Looking at the SQL its generating<br /><br /> CREATE DATABASE testpg84<br /> WITH ENCODING='UTF8'<br/> TEMPLATE=template0<br /> COLLATE='C'<br /> CTYPE='English_United States.1252'<br/> CONNECTION LIMIT=-1;<br /><br /> Shouldn't that be<br /><br /> LC_COLLATE<br /> LC_CType<br /><br/> according to the docs<br /><a href="http://www.postgresql.org/docs/8.4/static/sql-createdatabase.html">http://www.postgresql.org/docs/8.4/static/sql-createdatabase.html</a><br /><br/> If I hand create as<br /><br /><br /> CREATE DATABASE testpg84<br /> WITH ENCODING='UTF8'<br /> TEMPLATE=template0<br/> LC_COLLATE='C'<br /> LC_CTYPE='English_United States.1252'<br /> CONNECTIONLIMIT=-1;<br /><br /> works fine<br /><br /> Thanks,<br /> Regina<br /><br /></font><p><hr size="1" /><p><strong>The substance of this message, including any attachments, may be confidential, legally privileged and/or exemptfrom disclosure pursuant to Massachusetts law. It is intended solely for the addressee. If you received this in error,please contact the sender and delete the material from any computer. </strong><p><hr size="1" /><p><strong><font color="339900"size="2"> Help make the earth a greener place. If at all possible resist printing this email and join us insaving paper. </font></strong><p>
В списке pgadmin-support по дате отправления: