Index: openacs-4/contrib/packages/project-manager/tcl/project-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/project-manager/tcl/Attic/project-procs-postgresql.xql,v
diff -u -r1.2 -r1.3
--- openacs-4/contrib/packages/project-manager/tcl/project-procs-postgresql.xql	4 Sep 2003 22:45:22 -0000	1.2
+++ openacs-4/contrib/packages/project-manager/tcl/project-procs-postgresql.xql	26 Feb 2004 15:15:41 -0000	1.3
@@ -1,8 +1,49 @@
 <?xml version="1.0"?>
 
 <queryset>
-   <rdbms><type>postgresql</type><version>7.1</version></rdbms>
+  <rdbms><type>postgresql</type><version>7.3</version></rdbms>
+  
+  <fullquery name="project_manager::project::default_status_open.get_default_status_open">
+    <querytext>
+      select status_id 
+      from pm_project_status 
+      where status_type = 'o'
+      limit 1
+    </querytext>
+  </fullquery>
 
+  <fullquery name="project_manager::project::default_status_closed.get_default_status_closed">
+    <querytext>
+      select status_id 
+      from pm_project_status 
+      where status_type = 'c'
+      limit 1
+    </querytext>
+  </fullquery>
+
+  <fullquery name="project_manager::project::new.new_project_item">
+    <querytext>
+        select pm_project__new_project_item (
+                :project_name,
+                :project_code,
+                :parent_id,
+                :goal,
+                :description,
+                to_timestamp(:planned_start_date,'YYYY MM DD HH24 MI SS'),
+                to_timestamp(:planned_end_date,'YYYY MM DD HH24 MI SS'),
+                null,
+                null,
+                :ongoing_p,
+                :status_id,
+                :organization_id,
+                current_timestamp,
+                :creation_user,
+                :creation_ip,
+                :package_id
+        );
+    </querytext>
+  </fullquery>
+
   <fullquery name="project_manager::project::compute_status.select_project_children">
     <querytext>
         select