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.2 -r1.3
--- openacs-4/contrib/packages/project-manager/tcl/task-procs-postgresql.xql	26 Jan 2004 15:39:40 -0000	1.2
+++ openacs-4/contrib/packages/project-manager/tcl/task-procs-postgresql.xql	26 Feb 2004 15:15:41 -0000	1.3
@@ -1,11 +1,50 @@
 <?xml version="1.0"?>
 
 <queryset>
-    <fullquery name="project_manager::task::get_url.get_package_id">
-        <querytext>
-            obviously broken
-            select package_id from surveys
-            where survey_id=:object_id
-        </querytext>
-    </fullquery>
+  <rdbms><type>postgresql</type><version>7.3</version></rdbms>
+
+  <fullquery name="project_manager::task::default_status_open.get_default_status_open">
+    <querytext>
+      select status_id 
+      from pm_task_status 
+      where status_type = 'o'
+      limit 1
+    </querytext>
+  </fullquery>
+
+  <fullquery name="project_manager::task::default_status_closed.get_default_status_closed">
+    <querytext>
+      select status_id 
+      from pm_task_status 
+      where status_type = 'c'
+      limit 1
+    </querytext>
+  </fullquery>
+
+  <fullquery name="project_manager::task::get_url.get_package_id">
+    <querytext>
+      obviously broken
+      select package_id from surveys
+      where survey_id=:object_id
+    </querytext>
+  </fullquery>
+  
+  <fullquery name="project_manager::task::new.new_task_item">
+    <querytext>
+      select pm_task__new_task_item (
+      :project_id,
+      :title,
+      :description,
+      :end_date,
+      :percent_complete,
+      :estimated_hours_work,
+      :estimated_hours_work_min,
+      :estimated_hours_work_max,
+      :status_id,
+      coalesce (:creation_date,current_timestamp),
+      :creation_user,
+      :creation_ip,
+      :package_id)
+    </querytext>
+  </fullquery>
 </queryset>