Index: openacs-4/contrib/packages/project-manager/www/process-task-add-edit-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/project-manager/www/Attic/process-task-add-edit-postgresql.xql,v
diff -u -r1.4 -r1.5
--- openacs-4/contrib/packages/project-manager/www/process-task-add-edit-postgresql.xql	8 Oct 2003 20:16:11 -0000	1.4
+++ openacs-4/contrib/packages/project-manager/www/process-task-add-edit-postgresql.xql	10 Oct 2003 22:51:04 -0000	1.5
@@ -4,18 +4,19 @@
   <fullquery name="get_process_tasks">
     <querytext>
 	SELECT
-        process_task_id as pti,
-        one_line,
-        description,
-        estimated_hours_work,
-        estimated_hours_work_min,
-        estimated_hours_work_max
+        t.process_task_id as pti,
+        t.one_line,
+        t.description,
+        t.estimated_hours_work,
+        t.estimated_hours_work_min,
+        t.estimated_hours_work_max,
+        d.dependency_type
 	FROM
-        pm_process_task
+        pm_process_task t LEFT JOIN pm_process_task_dependency d ON t.process_task_id = d.process_task_id
         WHERE
-        process_task_id in ([join $process_task_id ", "])
+        t.process_task_id in ([join $process_task_id ", "])
         ORDER BY
-        process_task_id
+        t.process_task_id
     </querytext>
   </fullquery>