PATCH for CREATE DATABASE with COLLATE, CTYPE & CONNECTION LIMIT
| От | Ashesh Vashi |
|---|---|
| Тема | PATCH for CREATE DATABASE with COLLATE, CTYPE & CONNECTION LIMIT |
| Дата | |
| Msg-id | 49200512.3020009@enterprisedb.com обсуждение исходный текст |
| Ответы |
Re: PATCH for CREATE DATABASE with COLLATE, CTYPE
& CONNECTION LIMIT
|
| Список | pgadmin-hackers |
Hi All,
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
You may need to run embed-xrc.
I have followed this link to implement this.
http://developer.postgresql.org/pgdocs/postgres/sql-createdatabase.html
Range for the Connection limit is set to -1 to 1000.
Regards,
Ashesh
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
You may need to run embed-xrc.
I have followed this link to implement this.
http://developer.postgresql.org/pgdocs/postgres/sql-createdatabase.html
Range for the Connection limit is set to -1 to 1000.
Regards,
Ashesh
В списке pgadmin-hackers по дате отправления: