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.

Reply via email to