From: | "Obe, Regina" <robe(dot)dnd(at)cityofboston(dot)gov> |
---|---|
To: | <pgadmin-support(at)postgresql(dot)org> |
Subject: | Can't create 8.4 database when specifying collation and character type in 1.10 beta |
Date: | 2009-04-16 18:33:54 |
Message-ID: | 53F9CF533E1AA14EA1F8C5C08ABC08D204D7F299@ZDND.DND.boston.cob |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
I'm using 1.10.0 beta 2 -- the one that comes with EnterpriseDB 8.4 beta1.
When I try to create a new database and specify the collations and character type I get error something to the effect syntax error in collate.
Looking at the SQL its generating
CREATE DATABASE testpg84
WITH ENCODING='UTF8'
TEMPLATE=template0
COLLATE='C'
CTYPE='English_United States.1252'
CONNECTION LIMIT=-1;
Shouldn't that be
LC_COLLATE
LC_CType
according to the docs
http://www.postgresql.org/docs/8.4/static/sql-createdatabase.html
If I hand create as
CREATE DATABASE testpg84
WITH ENCODING='UTF8'
TEMPLATE=template0
LC_COLLATE='C'
LC_CTYPE='English_United States.1252'
CONNECTION LIMIT=-1;
works fine
Thanks,
Regina
-----------------------------------------
The substance of this message, including any attachments, may be
confidential, legally privileged and/or exempt from 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.
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2009-04-16 19:08:02 | Re: Can't create 8.4 database when specifying collation and character type in 1.10 beta |
Previous Message | Dave Page | 2009-04-16 15:41:17 | Re: Loading Data-Types takes quite long |