Index: openacs-4/packages/acs-messaging/sql/postgresql/acs-messaging-packages.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-messaging/sql/postgresql/acs-messaging-packages.sql,v
diff -u -r1.10.4.2 -r1.10.4.3
--- openacs-4/packages/acs-messaging/sql/postgresql/acs-messaging-packages.sql	2 Mar 2003 22:35:07 -0000	1.10.4.2
+++ openacs-4/packages/acs-messaging/sql/postgresql/acs-messaging-packages.sql	22 Apr 2003 00:25:49 -0000	1.10.4.3
@@ -5,7 +5,7 @@
 -- @author Phong Nguyen <phong@arsdigita.com>
 -- @author Jon Griffin <jon@jongriffin.com>
 -- @creation-date 2000-08-27
--- @cvs-id $Id$
+-- @cvs-id acs-messaging-packages.sql,v 1.10.4.2 2003/03/02 22:35:07 donb Exp
 --
 -- updated for OpenACS by Jon Griffin
 --
@@ -75,7 +75,7 @@
 ----------------
 
 create function acs_message__new (integer,integer,timestamptz,integer,
-varchar,varchar,varchar,varchar,varchar,text,integer,integer,integer,
+varchar,varchar,varchar,varchar,text,integer,integer,integer,integer,
 varchar,varchar,boolean)
 returns integer as '
 declare
Fisheye: Tag 1.1 refers to a dead (removed) revision in file `openacs-4/packages/acs-messaging/sql/postgresql/upgrade/upgrade-4.6.2-4.6.3.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Index: openacs-4/packages/static-pages/tcl/static-pages-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/static-pages/tcl/static-pages-procs-postgresql.xql,v
diff -u -r1.17.2.4 -r1.17.2.5
--- openacs-4/packages/static-pages/tcl/static-pages-procs-postgresql.xql	16 Dec 2002 07:48:12 -0000	1.17.2.4
+++ openacs-4/packages/static-pages/tcl/static-pages-procs-postgresql.xql	22 Apr 2003 00:28:12 -0000	1.17.2.5
@@ -42,7 +42,7 @@
 <fullquery name="sp_sync_cr_with_filesystem_internal.update_db_file">      
       <querytext>
 		update cr_revisions set content = :sp_filename
-		where revision_id = content_item__get_live_revisions(:static_page_id)
+		where revision_id = content_item__get_live_revision(:static_page_id)
    
       </querytext>
 </fullquery>
@@ -71,7 +71,8 @@
 <fullquery name="sp_sync_cr_with_filesystem_internal.insert_file_contents">
       <querytext>
 		update cr_revisions set content = :sp_filename
-		where revision_id = content_item__get_live_revisions(:static_page_id)      </querytext>
+		where revision_id = content_item__get_live_revision(:static_page_id)
+      </querytext>
 </fullquery>
 
 
Index: openacs-4/packages/static-pages/tcl/static-pages-procs.tcl
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/static-pages/tcl/static-pages-procs.tcl,v
diff -u -r1.11.2.13 -r1.11.2.14
--- openacs-4/packages/static-pages/tcl/static-pages-procs.tcl	6 Feb 2003 13:05:51 -0000	1.11.2.13
+++ openacs-4/packages/static-pages/tcl/static-pages-procs.tcl	22 Apr 2003 00:28:12 -0000	1.11.2.14
@@ -4,7 +4,7 @@
 
     @author Brandoch Calef (bcalef@arsdigita.com)
     @creation-date 2001-01-22
-    @cvs-id $Id$
+    @cvs-id static-pages-procs.tcl,v 1.11.2.13 2003/02/06 13:05:51 jeffd Exp
 }
 
 
@@ -246,10 +246,7 @@
 
     ns_mutex lock $mutex
 
-    if { ![nsv_array exists $nsv] } {
-        ns_mutex unlock $mutex
-        error "nsv array '$nsv' does not exist!"
-    } elseif { ![nsv_exists $nsv $package_id] } {
+    if { ![nsv_exists $nsv $package_id] } {
         # The package_id isn't in the array yet at all, so another copy
         # is not running.
         set other_start_time {}
Index: openacs-4/packages/survey/tcl/survey-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/survey/tcl/survey-procs-postgresql.xql,v
diff -u -r1.2.2.3 -r1.2.2.4
--- openacs-4/packages/survey/tcl/survey-procs-postgresql.xql	6 Nov 2002 14:57:53 -0000	1.2.2.3
+++ openacs-4/packages/survey/tcl/survey-procs-postgresql.xql	22 Apr 2003 00:28:48 -0000	1.2.2.4
@@ -28,6 +28,16 @@
 </querytext>
 </fullquery>
 
+<fullquery name="get_survey_info.n_completed">
+<querytext>
+    		    select count(distinct survey_response__initial_user_id(response_id))
+                    from 
+		    survey_responses
+		    where survey_id=:survey_id
+</querytext>
+</fullquery>
+
+
 <fullquery name="survey_do_notifications.get_response_info">
     <querytext>
 	select r.initial_response_id, r.responding_user_id, r.response_id,
@@ -78,4 +88,4 @@
 </querytext>
 </fullquery>
 
-</queryset>
\ No newline at end of file
+</queryset>