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