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.