Sorted Function List in New Trigger form

["Robins Tharakan" <tharakan(at)gmail(dot)com>]

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())