Index: openacs-4/contrib/packages/project-manager/www/process-dependency-add-edit-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/project-manager/www/Attic/process-dependency-add-edit-postgresql.xql,v
diff -u -r1.2 -r1.3
--- openacs-4/contrib/packages/project-manager/www/process-dependency-add-edit-postgresql.xql	3 Oct 2003 23:13:15 -0000	1.2
+++ openacs-4/contrib/packages/project-manager/www/process-dependency-add-edit-postgresql.xql	10 Oct 2003 22:51:04 -0000	1.3
@@ -5,11 +5,12 @@
       select
         t.process_task_id as task_id,
         t.one_line as task_title,
-        t.description
+        t.description,
+        d.parent_task_id
 	FROM
-	pm_process_task t
+	pm_process_task t LEFT JOIN pm_process_task_dependency d ON t.process_task_id = d.process_task_id
         WHERE
-        t.process_task_id in ([join $process_task_id ", "])
+        t.process_task_id in ([join $use_dependency ", "])
     </querytext>
   </fullquery>
 
@@ -39,10 +40,17 @@
     </querytext>
   </fullquery>
 
+  <fullquery name="delete_dependency">
+    <querytext>
+        DELETE FROM pm_process_task_dependency
+        WHERE process_task_id = :tsk_id
+    </querytext>
+  </fullquery>
+
   <fullquery name="new_dependency">
     <querytext>
         INSERT INTO pm_process_task_dependency
-        (dependency_id, task_id, parent_task_id, dependency_type) 
+        (dependency_id, process_task_id, parent_task_id, dependency_type) 
         VALUES
         (:dependency_id, :tsk_id, :parent_tsk_id, :type_id)
     </querytext>