Index: openacs-4/packages/project-manager-portlet/lib/tasks-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/project-manager-portlet/lib/tasks-postgresql.xql,v
diff -u -r1.4 -r1.5
--- openacs-4/packages/project-manager-portlet/lib/tasks-postgresql.xql	25 Aug 2005 19:46:03 -0000	1.4
+++ openacs-4/packages/project-manager-portlet/lib/tasks-postgresql.xql	15 Sep 2005 22:43:53 -0000	1.5
@@ -22,9 +22,6 @@
 	t.latest_finish - current_date as days_to_latest_finish,
 	to_char(t.end_date,'YYYY-MM-DD HH24:MI:SS') as end_date,
 	t.end_date - current_date as days_to_end_date,
-        u.person_id,
-        u.first_names,
-        u.last_name,
         t.percent_complete,
         t.estimated_hours_work,
         t.estimated_hours_work_min,
@@ -34,6 +31,7 @@
         s.description as status_description,
         r.is_lead_p,
 	t.priority,
+	t.party_id,
         p.title as project_name
 	FROM
 	(select tr.item_id,
@@ -55,10 +53,6 @@
 		tr.priority
          from pm_tasks_revisionsx tr, pm_task_assignment ta, pm_roles pr
          where ta.task_id = tr.item_id and ta.role_id = pr.role_id $extra_query) t
-           LEFT JOIN 
-           persons u 
-           ON 
-           t.party_id = u.person_id 
            LEFT JOIN
            pm_roles r
            ON t.role_id = r.role_id,