Please find the patch for "CREATE DATABASE" with COLLATE, CTYPE & CONNECTION LIMIT.
Changed the following files: * include/schema/pgDatabase.h - Declarations of variables & functions for collate, ctype & connection limit * include/dlg/dlgDatabase.h - Declaration of the event handlers to take care the auto-completion of ctlComboBox for collate & ctype * schema/pgDatabase.cpp - Made modifications in GetSql function for reverse engineering of the query - Made modifications in CreateObjects for fetching ctype, collate and connection limit details from pg_database catalog for existing databases, saved as datctype, datcollate, datconnlimit respectively. * dlg/dlgDatabase.cpp - Defined the following variables: + cbCollate as ctlComboBox + cbCType as ctlComboBox + spConnLimit as wxSpinCtrl - Defined event-handlers for auto-completion operation for cbCollate & cbCType - COLLATE & CTYPE takes locale as input value. Currently, we don't have any way to get the supported server-locale on client side. :( Hence, I have kept the values fetched from the already used locale values earlier along with C & POSIX. - Made modification for Create a new database & editing existing database (properties). * ui/dlgDatabase.xrc - Increased the height of the property dialog by 10 - Added controls for collate, ctype & connection limit