Index: openacs-4/packages/acs-admin/www/users/complex-search.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-admin/www/users/complex-search.tcl,v
diff -u -r1.8 -r1.9
--- openacs-4/packages/acs-admin/www/users/complex-search.tcl	17 May 2003 09:36:54 -0000	1.8
+++ openacs-4/packages/acs-admin/www/users/complex-search.tcl	17 Jul 2003 02:37:03 -0000	1.9
@@ -201,7 +201,7 @@
         append query "\nwhere [join $where_clause "\n$where_conjunction "]"
     }
 }
-append query "\norder by upper(first_names), upper(last_name)"
+append query "\norder by first_names, last_name"
 
 set i 0
 
Index: openacs-4/packages/acs-api-browser/www/plsql-subprograms-all-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-api-browser/www/plsql-subprograms-all-postgresql.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/acs-api-browser/www/plsql-subprograms-all-postgresql.xql	17 Feb 2002 22:10:12 -0000	1.1
+++ openacs-4/packages/acs-api-browser/www/plsql-subprograms-all-postgresql.xql	17 Jul 2003 02:35:27 -0000	1.2
@@ -8,7 +8,7 @@
 
 	select proname as name, 'FUNCTION' as type 
 	from pg_proc 
-	where proowner=(select usesysid from pg_shadow 
+	where proowner=(select usesysid from pg_user
 	                where usename = current_user) 
 	order by proname