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.7 -r1.8 --- openacs-4/contrib/packages/project-manager/www/tasks-postgresql.xql 3 Jun 2004 21:32:13 -0000 1.7 +++ openacs-4/contrib/packages/project-manager/www/tasks-postgresql.xql 24 Jul 2004 08:33:56 -0000 1.8 @@ -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