Index: openacs-4/packages/project-manager/tcl/project-manager-procs-postgresql.xql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/project-manager/tcl/project-manager-procs-postgresql.xql,v diff -u -N -r1.3 -r1.4 --- openacs-4/packages/project-manager/tcl/project-manager-procs-postgresql.xql 26 May 2005 09:34:29 -0000 1.3 +++ openacs-4/packages/project-manager/tcl/project-manager-procs-postgresql.xql 27 Jul 2005 19:04:37 -0000 1.4 @@ -43,13 +43,11 @@ p.person_id FROM persons p, - acs_rels r, - membership_rels mr + acs_object_party_privilege_map ppm WHERE - r.object_id_one = :user_group_id and - mr.rel_id = r.rel_id and - p.person_id = r.object_id_two and - member_state = 'approved' + ppm.object_id = :package_id + and ppm.privilege = 'read' + and ppm.party_id = p.person_id ORDER BY name