Postgres Pro
Downloads
Home   >   mailing lists

Thread: CREATE DATABASE wrong SYNTAX

CREATE DATABASE wrong SYNTAX

From
"Jan-Peter Seifert"
Date:
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

Re: CREATE DATABASE wrong SYNTAX

From
Dave Page
Date:
On Wed, Apr 22, 2009 at 5:10 PM, Jan-Peter Seifert
<Jan-Peter.Seifert@gmx.de> wrote:
> Hello,
>
> when you create a new database with pgAdmin III 1.10 beta 2 specifying a locale different from the server pgAdmin
sendsa 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.

It was correct when beta2 was released :-). They changed the syntax at
the last minute in PostgreSQL - we've already fixed it for beta 3.

-- 
Dave Page
EnterpriseDB UK:   http://www.enterprisedb.com