Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

Can't create 8.4 database when specifying collation and character type in 1.10 beta



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.


Home | Main Index | Thread Index

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group