Index: openacs-4/packages/acs-subsite/www/admin/site-map/index-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/www/admin/site-map/index-postgresql.xql,v
diff -u -r1.7 -r1.8
--- openacs-4/packages/acs-subsite/www/admin/site-map/index-postgresql.xql	21 Jun 2002 19:08:33 -0000	1.7
+++ openacs-4/packages/acs-subsite/www/admin/site-map/index-postgresql.xql	19 Aug 2002 14:50:42 -0000	1.8
@@ -22,11 +22,12 @@
         <querytext>
             select package_id,
                    package_key,
+                   pretty_name as package_pretty_name,
                    apm_package_type__num_parameters(package_key) as parameter_count,
                    node_id, url, parent_url, name, root_p, mylevel, object_id,
                    object_name, directory_p, parent_id, n_children,
                    (select case when acs_permission__permission_p(object_id, :user_id, 'admin') = 't' then 1 else 0 end) as object_admin_p
-            from apm_packages p right outer join
+            from apm_packages p join apm_package_types using (package_key) right outer join
                  (select n.node_id,
                          site_node__url(n.node_id) as url,
                          site_node__url(n.parent_id) as parent_url,