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  (Guillaume Lelarge <guillaume@lelarge.info>)
Список 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

В списке pgadmin-hackers по дате отправления:

Предыдущее
От: Quan Zongliang
Дата:
Сообщение: Re: the patch: support for DESC/NULLS FIRST/NULLS LAST
Следующее
От: Guillaume Lelarge
Дата:
Сообщение: Re: PATCH for CREATE DATABASE with COLLATE, CTYPE & CONNECTION LIMIT