Index: openacs-4/packages/acs-subsite/www/admin/rel-segments/one-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/www/admin/rel-segments/one-postgresql.xql,v diff -u -r1.2 -r1.2.4.1 --- openacs-4/packages/acs-subsite/www/admin/rel-segments/one-postgresql.xql 28 Nov 2001 18:39:39 -0000 1.2 +++ openacs-4/packages/acs-subsite/www/admin/rel-segments/one-postgresql.xql 17 Feb 2003 03:15:45 -0000 1.2.4.1 @@ -2,19 +2,7 @@ postgresql7.1 - - - - - select count(*) as number_elements - from rel_segment_party_map map - where acs_permission__permission_p(map.party_id, :user_id, 'read') - and map.segment_id = :segment_id - - - - Index: openacs-4/packages/acs-subsite/www/admin/rel-segments/one.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/www/admin/rel-segments/one.xql,v diff -u -r1.1 -r1.1.4.1 --- openacs-4/packages/acs-subsite/www/admin/rel-segments/one.xql 15 May 2001 16:59:00 -0000 1.1 +++ openacs-4/packages/acs-subsite/www/admin/rel-segments/one.xql 17 Feb 2003 03:15:45 -0000 1.1.4.1 @@ -15,12 +15,14 @@ - select count(*) as number_elements - from rel_segment_party_map map, acs_object_party_privilege_map perm - where perm.object_id = map.party_id - and perm.party_id = :user_id - and perm.privilege = 'read' - and map.segment_id = :segment_id + select count(*) as number_elements + from rel_segment_party_map map + where map.segment_id = :segment_id + and exists (select 1 + from acs_object_party_privilege_map perm + where perm.object_id = map.party_id + and perm.party_id = :user_id + and perm.privilege = 'read')