Index: openacs-4/contrib/packages/project-manager/www/tasks-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/project-manager/www/Attic/tasks-postgresql.xql,v
diff -u -r1.1.2.2 -r1.1.2.3
--- openacs-4/contrib/packages/project-manager/www/tasks-postgresql.xql	10 Jan 2004 01:04:02 -0000	1.1.2.2
+++ openacs-4/contrib/packages/project-manager/www/tasks-postgresql.xql	15 Jan 2004 01:20:49 -0000	1.1.2.3
@@ -23,10 +23,16 @@
         p.first_names || ' ' || p.last_name as full_name,
         r.one_line as role
         FROM
-        pm_tasks ts, (select * from pm_tasks_revisionsx t LEFT JOIN pm_task_assignment ta on t.item_id = ta.task_id) t LEFT JOIN persons p ON t.party_id = p.person_id, pm_roles r
+        pm_tasks ts, 
+        pm_tasks_revisionsx t 
+          LEFT JOIN pm_task_assignment ta
+          ON t.item_id = ta.task_id
+            LEFT JOIN persons p 
+            ON ta.party_id = p.person_id,
+        pm_roles r
         WHERE
         ts.task_id  = t.item_id and
-        t.role_id  = r.role_id
+        ta.role_id = r.role_id 
         [template::list::filter_where_clauses -and -name tasks]
         [template::list::orderby_clause -orderby -name tasks]
     </querytext>