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.5.2.2 -r1.5.2.3 --- openacs-4/contrib/packages/project-manager/www/tasks-postgresql.xql 2 Jul 2004 23:13:49 -0000 1.5.2.2 +++ openacs-4/contrib/packages/project-manager/www/tasks-postgresql.xql 16 Jul 2004 20:59:41 -0000 1.5.2.3 @@ -32,7 +32,7 @@ p.first_names || ' ' || p.last_name as full_name, (select one_line from pm_roles r where ta.role_id = r.role_id) as role FROM - pm_tasks ts, + pm_tasks_active ts, cr_items i, pm_tasks_revisionsx t LEFT JOIN pm_task_assignment ta