Index: openacs-4/packages/project-manager/lib/tasks-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/project-manager/lib/tasks-postgresql.xql,v
diff -u -r1.6 -r1.7
--- openacs-4/packages/project-manager/lib/tasks-postgresql.xql	11 Aug 2005 07:53:44 -0000	1.6
+++ openacs-4/packages/project-manager/lib/tasks-postgresql.xql	23 Aug 2005 16:37:50 -0000	1.7
@@ -40,6 +40,8 @@
         p.title as project_name,
 	ar.object_id_two as logger_project
 	FROM
+	pm_roles pr,
+	pm_task_assignment pa,
 	(select tr.item_id,
                 ta.party_id,
                 ta.role_id,
@@ -102,6 +104,8 @@
      select distinct task_item_id from (SELECT
         t.item_id as task_item_id
 	FROM
+	pm_roles pr,
+	pm_task_assignment pa,
 	(select tr.item_id,
                 ta.party_id,
                 ta.role_id,