Hello,
when you create a new database with pgAdmin III 1.10 beta 2 specifying a locale different from the server pgAdmin sends
awrong CREATE DATABASE syntax to the server - COLLATE instead of LC_COLLATE and CYTPE instead of LC_CTYPE.
http://www.postgresql.org/docs/8.4/static/sql-createdatabase.html
Just in case nobody mentioned this yet.
With best regards,
Peter
--
Neu: GMX FreeDSL Komplettanschluss mit DSL 6.000 Flatrate + Telefonanschluss für nur 17,95 Euro/mtl.!*
http://dslspecial.gmx.de/freedsl-surfflat/?ac=OM.AD.PD003K11308T4569a