[pgadmin-hackers] SVN Commit by dpage: r7074 - in branches/REL-1_8_0_PATCHES/pgadmin3: . pgadmin/schema
Author: dpage Date: 2008-02-13 15:51:58 + (Wed, 13 Feb 2008) New Revision: 7074 Revision summary: http://svn.pgadmin.org/cgi-bin/viewcvs.cgi/?rev=7074&view=rev Log: Hide array variants of table-types in datatype selectors where we already hide the table type itself. Modified: branches/REL-1_8_0_PATCHES/pgadmin3/CHANGELOG branches/REL-1_8_0_PATCHES/pgadmin3/pgadmin/schema/pgDatatype.cpp ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
[pgadmin-hackers] SVN Commit by dpage: r7075 - in trunk/pgadmin3: . pgadmin/schema
Author: dpage Date: 2008-02-13 15:52:27 + (Wed, 13 Feb 2008) New Revision: 7075 Revision summary: http://svn.pgadmin.org/cgi-bin/viewcvs.cgi/?rev=7075&view=rev Log: Hide array variants of table-types in datatype selectors where we already hide the table type itself. Modified: trunk/pgadmin3/CHANGELOG trunk/pgadmin3/pgadmin/schema/pgDatatype.cpp ---(end of broadcast)--- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate
[pgadmin-hackers] SVN Commit by dpage: r7076 - trunk/pgadmin3
Author: dpage Date: 2008-02-13 15:56:07 + (Wed, 13 Feb 2008) New Revision: 7076 Revision summary: http://svn.pgadmin.org/cgi-bin/viewcvs.cgi/?rev=7076&view=rev Log: Add the table types UI changes to the TODO per discussion. Modified: trunk/pgadmin3/TODO ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
[pgadmin-hackers] ComboBox for FK columns in EditGrid
Hi, In searching for what to add next to PgAdmin, I saw that the PgAdmin TODO list has listed ComboBoxes in ForeignKey columns as one of its requirements. Is anyone working on it ? I would want to give it a try if I could understand wxWidgets a little bit more. And for that, any recommendations as to which control to use ? Should I use wxVListBox (in case the list is large) or simply use wxListView and warn for large lists ? Or any other ? *Robins*
Re: [pgadmin-hackers] ComboBox for FK columns in EditGrid
On Feb 13, 2008 4:33 PM, Robins Tharakan <[EMAIL PROTECTED]> wrote: > Hi, > > In searching for what to add next to PgAdmin, I saw that the PgAdmin TODO > list has listed ComboBoxes in ForeignKey columns as one of its requirements. > > Is anyone working on it ? > I would want to give it a try if I could understand wxWidgets a little bit > more. > You mean in the edit grid as selectable values? Sure, go for it. > And for that, any recommendations as to which control to use ? > Should I use wxVListBox (in case the list is large) or simply use wxListView > and warn for large lists ? Or any other ? wxComboxBox would seem more appropriate - list boxes are not really an appropriate control from a UI perspective. You will need to give some though to how the data will be populated, especially when there are a lot of rows on the child table. I would consider using a single source of data for each column, and maybe list 50 rows at a time, but add a pseudo-option as the last item which, if selected, will grab the next 50 rows. Use a cursor to get the data (might be a good time to think about adding cursor support to pgSet), and cache it so we only have to get it once when the form is loaded. Sounds like a fun little project actually... -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com The Oracle-compatible database company ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
Re: [pgadmin-hackers] Sorted Function List in New Trigger form
On Feb 13, 2008 6:02 PM, Robins Tharakan <[EMAIL PROTECTED]> wrote: > Hi, > > While working at office today I realised that it was quite annoying to get > and unsorted function list in the 'New Trigger' form. > > (While I do other stuff, I thought I should take care of these trivials > before it gets out of my mind.) > > Attached is a small patch to sort that list. Sounds good - patch applied, thanks! -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com The Oracle-compatible database company ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings
[pgadmin-hackers] Sorted Function List in New Trigger form
Hi,
While working at office today I realised that it was quite annoying to get
and unsorted function list in the 'New Trigger' form.
(While I do other stuff, I thought I should take care of these trivials
before it gets out of my mind.)
Attached is a small patch to sort that list.
*Robins*
Index: pgadmin/dlg/dlgTrigger.cpp
===
--- pgadmin/dlg/dlgTrigger.cpp (revision 7073)
+++ pgadmin/dlg/dlgTrigger.cpp (working copy)
@@ -124,7 +124,8 @@
pgSet *set=connection->ExecuteSet(
wxT("SELECT quote_ident(nspname) || '.' || quote_ident(proname)\n")
wxT(" FROM pg_proc p, pg_namespace n, pg_language l\n")
-wxT(" WHERE p.pronamespace = n.oid AND p.prolang = l.oid AND l.lanname != 'edbspl' AND prorettype=") + NumToStr(PGOID_TYPE_TRIGGER) + sysRestr);
+wxT(" WHERE p.pronamespace = n.oid AND p.prolang = l.oid AND l.lanname != 'edbspl' AND prorettype=") + NumToStr(PGOID_TYPE_TRIGGER) + sysRestr +
+wxT(" ORDER BY nspname ASC, proname ASC "));
if (set)
{
while (!set->Eof())
---(end of broadcast)---
TIP 7: You can help support the PostgreSQL project by donating at
http://www.postgresql.org/about/donate
[pgadmin-hackers] SVN Commit by dpage: r7077 - in trunk/pgadmin3: . pgadmin/dlg
Author: dpage Date: 2008-02-13 19:20:01 + (Wed, 13 Feb 2008) New Revision: 7077 Revision summary: http://svn.pgadmin.org/cgi-bin/viewcvs.cgi/?rev=7077&view=rev Log: Sort the functions in the combo box on the Trigger dialogue [Robins Tharakan] Modified: trunk/pgadmin3/CHANGELOG trunk/pgadmin3/pgadmin/dlg/dlgTrigger.cpp ---(end of broadcast)--- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate
