Index: openacs-4/packages/acs-subsite/www/admin/site-map/unmounted-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/www/admin/site-map/unmounted-postgresql.xql,v diff -u -N --- openacs-4/packages/acs-subsite/www/admin/site-map/unmounted-postgresql.xql 18 Jun 2018 13:17:59 -0000 1.5 +++ /dev/null 1 Jan 1970 00:00:00 -0000 @@ -1,36 +0,0 @@ - - - - postgresql7.1 - - - - select package_id, instance_name as name, package_key - from apm_packages p - where (acs_permission__permission_p(package_id, :user_id, 'read') or - acs_permission__permission_p(package_id, acs__magic_object_id('the_public'), 'read')) - and not (select singleton_p from apm_package_types - where package_key = p.package_key) - and not exists (select 1 - from site_nodes - where object_id = package_id) - order by name - - - - - - select package_id, instance_name as name, package_key - from apm_packages p - where (acs_permission__permission_p(package_id, :user_id, 'read') or - acs_permission__permission_p(package_id, acs__magic_object_id('the_public'), 'read')) - and (select singleton_p from apm_package_types - where package_key = p.package_key) - and not exists (select 1 - from site_nodes - where object_id = package_id) - order by name - - - -