PATCH for CREATE DATABASE with COLLATE, CTYPE & CONNECTION LIMIT

From: Ashesh Vashi <ashesh(dot)vashi(at)enterprisedb(dot)com>
To: pgadmin-hackers <pgadmin-hackers(at)postgresql(dot)org>
Subject: PATCH for CREATE DATABASE with COLLATE, CTYPE & CONNECTION LIMIT
Date: 2008-11-16 11:33:38
Message-ID: 49200512.3020009@enterprisedb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Attachment Content-Type Size
COLLATE_CTYPE_CONN_LIMIT.patch text/x-patch 14.5 KB

Responses

Browse pgadmin-hackers by date

  From Date Subject
Next Message Guillaume Lelarge 2008-11-16 19:40:24 Re: PATCH for CREATE DATABASE with COLLATE, CTYPE & CONNECTION LIMIT
Previous Message Quan Zongliang 2008-11-15 14:08:34 Re: the patch: support for DESC/NULLS FIRST/NULLS LAST