Index: openacs-4/packages/assessment/www/assessment-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/www/Attic/assessment-postgresql.xql,v
diff -u -r1.10 -r1.11
--- openacs-4/packages/assessment/www/assessment-postgresql.xql	23 Jan 2005 18:10:48 -0000	1.10
+++ openacs-4/packages/assessment/www/assessment-postgresql.xql	24 Jan 2005 14:54:30 -0000	1.11
@@ -30,28 +30,35 @@
 	</querytext>
 </fullquery>
 	
-	<fullquery name="session_start">
-		<querytext>
-    UPDATE as_sessions
-    SET creation_datetime = NOW()
-    WHERE session_id = :session_id
-		</querytext>
-	</fullquery>
+<fullquery name="session_start">
+	<querytext>
 
-	<fullquery name="session_updated">
-		<querytext>
+	update as_sessions
+	set creation_datetime = NOW()
+	where session_id = :session_id
+	and creation_datetime is null
+
+	</querytext>
+</fullquery>
+
+<fullquery name="session_updated">
+	<querytext>
+
 	UPDATE as_sessions
 	SET last_mod_datetime = NOW()
 	WHERE session_id = :session_id
-		</querytext>
-	</fullquery>
 
-	<fullquery name="session_finished">
-		<querytext>
+	</querytext>
+</fullquery>
+
+<fullquery name="session_finished">
+	<querytext>
+
 	UPDATE as_sessions
 	SET completed_datetime = NOW()
 	WHERE session_id = :session_id
-		</querytext>
-	</fullquery>
 
+	</querytext>
+</fullquery>
+
 </queryset>