Index: openacs-4/packages/acs-subsite/www/admin/site-map/mount-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/www/admin/site-map/mount-postgresql.xql,v diff -u -r1.1 -r1.2 --- openacs-4/packages/acs-subsite/www/admin/site-map/mount-postgresql.xql 22 Apr 2001 16:13:15 -0000 1.1 +++ openacs-4/packages/acs-subsite/www/admin/site-map/mount-postgresql.xql 30 Apr 2001 20:11:24 -0000 1.2 @@ -1,15 +1,20 @@ + -postgresql7.1 + postgresql7.1 - - - select site_node__url(:node_id) from dual - + + + + select site_node__url(:node_id) + + - - + + + + select package_id, acs_object__name(package_id) as name from apm_packages @@ -19,12 +24,16 @@ and not exists (select 1 from site_nodes where object_id = package_id) + order by name - + + - - + + + + select package_id, acs_object__name(package_id) as name from apm_packages @@ -34,11 +43,14 @@ from site_nodes where object_id = package_id) order by name - + + - - + + + + select package_id, acs_object__name(package_id) as name from apm_packages @@ -49,7 +61,9 @@ from site_nodes where object_id = package_id) order by name - + + +