Index: openacs-4/contrib/packages/project-manager/www/task-constraint-add-edit-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/project-manager/www/Attic/task-constraint-add-edit-postgresql.xql,v
diff -u -r1.1 -r1.2
--- openacs-4/contrib/packages/project-manager/www/task-constraint-add-edit-postgresql.xql	7 Aug 2003 23:08:45 -0000	1.1
+++ openacs-4/contrib/packages/project-manager/www/task-constraint-add-edit-postgresql.xql	8 Aug 2003 22:24:14 -0000	1.2
@@ -43,11 +43,11 @@
   <fullquery name="get_task_id">
     <querytext>
       select
-        t.item_id
+        item_id
 	FROM
-	pm_tasks_revisionsx t
+	pm_tasks_revisionsx
         WHERE
-        t.revision_id = :tr
+        revision_id = :tr
     </querytext>
   </fullquery>
 
@@ -63,6 +63,18 @@
     </querytext>
   </fullquery>
 
+  <fullquery name="get_const_tasks">
+    <querytext>
+      select
+        r.item_id, r.title as task_title        
+	FROM
+        pm_tasks_revisionsx r, cr_items i 
+        WHERE
+        r.parent_id = :project_item_id and
+        r.revision_id = i.live_revision
+    </querytext>
+  </fullquery>
+
   <fullquery name="new_constraint">
     <querytext>
         INSERT INTO pm_task_constraints
@@ -75,11 +87,11 @@
   <fullquery name="get_parent_project">
     <querytext>
       select
-        t.parent_id
+        parent_id
 	FROM
-	pm_tasks_revisionsx t
+	pm_tasks_revisionsx 
         WHERE
-        t.revision_id = '[lindex $task_revisions 0]'
+        revision_id = '[lindex $task_revisions 0]'
     </querytext>
   </fullquery>
 </queryset>