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

CREATE DATABASE wrong SYNTAX


  • From: "Jan-Peter Seifert" <Jan-Peter(dot)Seifert(at)gmx(dot)de>
  • To: pgadmin-support(at)postgresql(dot)org
  • Subject: CREATE DATABASE wrong SYNTAX
  • Date: Wed, 22 Apr 2009 18:10:48 +0200
  • Message-id: <20090422161048.122450@gmx.net> <text/plain>

Hello,

when you create a new database with pgAdmin III 1.10 beta 2 specifying a locale different from the server pgAdmin sends a wrong 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



Home | Main Index | Thread Index

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