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
