Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
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: Wed, 22 Apr 2009 17:25:04 +0100
- Message-id: <937d27e10904220925k1b7cdf50hf9c5881dbd905c47@mail.gmail.com> <text/plain>
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
- References:
- CREATE DATABASE wrong SYNTAX
- From: Jan-Peter Seifert
- CREATE DATABASE wrong SYNTAX
- Prev by Date: Re: pgAgent absent from win32 beta distributions?
- Next by Date: wrong handling of character params in debugger
- Previous by thread: CREATE DATABASE wrong SYNTAX
- Next by thread: wrong handling of character params in debugger
- Indexes: