Index: openacs-4/contrib/packages/project-manager/tcl/task-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/project-manager/tcl/Attic/task-procs-postgresql.xql,v
diff -u -r1.1.2.4 -r1.1.2.5
--- openacs-4/contrib/packages/project-manager/tcl/task-procs-postgresql.xql	27 Feb 2004 22:46:13 -0000	1.1.2.4
+++ openacs-4/contrib/packages/project-manager/tcl/task-procs-postgresql.xql	6 Mar 2004 00:29:24 -0000	1.1.2.5
@@ -3,7 +3,7 @@
 <queryset>
   <rdbms><type>postgresql</type><version>7.3</version></rdbms>
 
-  <fullquery name="pm::task::get_task_item_id.get_task_item_id">
+  <fullquery name="pm::task::get_item_id.get_item_id">
     <querytext>
       SELECT
       i.item_id
@@ -16,6 +16,17 @@
     </querytext>
   </fullquery>
 
+  <fullquery name="pm::task::get_revision_id.get_revision_id">
+    <querytext>
+      SELECT
+      live_revision
+      FROM
+      cr_items i
+      WHERE
+      i.item_id = :task_item_id
+    </querytext>
+  </fullquery>
+
   <fullquery name="pm::task::default_status_open.get_default_status_open">
     <querytext>
       select status_id 
@@ -42,14 +53,14 @@
     </querytext>
   </fullquery>
   
-  <fullquery name="pm::task::update.new_task_revision">
+  <fullquery name="pm::task::edit.new_task_revision">
     <querytext>
       select pm_task__new_task_revision (
       :task_item_id,
       :project_item_id,
       :title,
       :description,
-      [pm::project::util::datenvl -value $end_date -value_if_null "null" -value_if_not_null "to_timestamp('$end_date','YYYY MM DD HH24 MI SS')"],
+      [pm::util::datenvl -value $end_date -value_if_null "null" -value_if_not_null "to_timestamp('$end_date','YYYY MM DD HH24 MI SS')"],
       :percent_complete,
       :estimated_hours_work,
       :estimated_hours_work_min,