Thread: 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