Index: openacs-4/packages/survey/survey.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/survey/survey.info,v
diff -u -r1.3 -r1.4
--- openacs-4/packages/survey/survey.info	16 Sep 2002 01:12:04 -0000	1.3
+++ openacs-4/packages/survey/survey.info	16 Sep 2002 19:53:14 -0000	1.4
@@ -14,9 +14,9 @@
     </database-support>
         <owner url="mailto:dave@thedesignexperience.org">Dave Bauer</owner>
         <owner url="mailto:luke@museatech.net">Luke Pond</owner>
-        <summary>New version of survey package OpenACS</summary>
-        <vendor url="http://openacs.org">OpenACS</vendor>
-        <description format="text/plain">New version of survey package OpenACS</description>
+        <summary>New version of survey package for dotLRN/OpenACS4.5</summary>
+        <vendor url="http://dotlrn.mit.edu">dotLRN</vendor>
+        <description format="text/plain">New version of survey package for dotLRN/OpenACS4.5</description>
 
         <provides url="survey" version="0.1d"/>
         <requires url="notifications" version="0.1"/>
@@ -174,6 +174,7 @@
             <file type="content_page" path="www/process-response.tcl"/>
             <file type="query_file" path="www/process-response.xql"/>
             <file type="query_file" db_type="oracle" path="www/respond-oracle.xql"/>
+            <file type="query_file" db_type="postgresql" path="www/respond-postgresql.xql"/>
             <file type="content_page" path="www/respond.adp"/>
             <file type="content_page" path="www/respond.tcl"/>
             <file type="query_file" path="www/respond.xql"/>
@@ -182,8 +183,8 @@
             <file type="query_file" path="www/view-attachment.xql"/>
         </files>
         <parameters>
-            <parameter datatype="number"  min_n_values="1"  max_n_values="1"  name="survey_enabled_default_p"  default="0" description="Are surveys enabled by default upon creation?"/>
             <parameter datatype="number"  min_n_values="1"  max_n_values="1"  name="allow_question_deavtivation_p"  default="0" description="Allow questions to be set inactive"/>
+            <parameter datatype="number"  min_n_values="1"  max_n_values="1"  name="survey_enabled_default_p"  default="0" description="Are surveys enabled by default upon creation?"/>
         </parameters>
 
     </version>
Index: openacs-4/packages/survey/www/respond-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/survey/www/respond-postgresql.xql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/survey/www/respond-postgresql.xql	16 Sep 2002 19:53:15 -0000	1.1
@@ -0,0 +1,24 @@
+<?xml version="1.0"?>
+
+<queryset>
+   <rdbms><type>postgresql</type><version>7.1</version></rdbms>
+
+<fullquery name="get_initial_response">      
+      <querytext>
+      
+	select survey_response__initial_response_id(:response_id) as initial_response_id from dual
+
+      </querytext>
+</fullquery>
+
+<fullquery name="count_responses">      
+      <querytext>
+      select count(*) from survey_responses
+	where survey_id=:survey_id
+	and survey_response__initial_user_id(response_id)=:user_id
+	and initial_response_id is null
+      </querytext>
+</fullquery>
+
+ 
+</queryset>