Re: CREATE DATABASE wrong SYNTAX

From: Dave Page <dpage(at)pgadmin(dot)org>
To: Jan-Peter Seifert <Jan-Peter(dot)Seifert(at)gmx(dot)de>
Cc: pgadmin-support(at)postgresql(dot)org
Subject: Re: CREATE DATABASE wrong SYNTAX
Date: 2009-04-22 16:25:04
Message-ID: 937d27e10904220925k1b7cdf50hf9c5881dbd905c47@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

On Wed, Apr 22, 2009 at 5:10 PM, Jan-Peter Seifert
<Jan-Peter(dot)Seifert(at)gmx(dot)de> wrote:
> 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.

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

In response to

Browse pgadmin-support by date

  From Date Subject
Next Message Wolfgang Pasche 2009-04-22 18:24:01 wrong handling of character params in debugger
Previous Message Jan-Peter Seifert 2009-04-22 16:10:48 CREATE DATABASE wrong SYNTAX