Обсуждение: BUG #4760: unexpected syntax error with CREATE DATABASE

The following bug has been logged online:

Bug reference:      4760
Logged by:
Email address:      CUeberall@web.de
PostgreSQL version: 8.4-beta1
Operating system:   Windows XP
Description:        unexpected syntax error with CREATE DATABASE
Details:

CREATE DATABASE "XYZ"
  WITH ENCODING='UTF8'
       OWNER=postgres
       COLLATE='German_Germany'
       CTYPE='German_Germany'
       CONNECTION LIMIT=-1;

FEHLER:  Syntaxfehler bei »COLLATE«
ZEILE 4:        COLLATE = 'German_Germany'

CUeberall@web.de wrote:
> ...
> PostgreSQL version: 8.4-beta1
> ...
>
> CREATE DATABASE "XYZ"
>   WITH ENCODING='UTF8'
>        OWNER=postgres
>        COLLATE='German_Germany'
>        CTYPE='German_Germany'
>        CONNECTION LIMIT=-1;

The COLLATE and CTYPE options were renamed to LC_COLLATE and LC_CTYPE a
few days before packaging beta1. If there's still mentions of
COLLATE/CTYPE somewhere in the docs, please let me know.

--
   Heikki Linnakangas
   EnterpriseDB   http://www.enterprisedb.com