Index: openacs-4/packages/evaluation/www/admin/tasks/solution-add-edit-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/evaluation/www/admin/tasks/solution-add-edit-postgresql.xql,v
diff -u -r1.5 -r1.6
--- openacs-4/packages/evaluation/www/admin/tasks/solution-add-edit-postgresql.xql	24 Aug 2004 22:40:33 -0000	1.5
+++ openacs-4/packages/evaluation/www/admin/tasks/solution-add-edit-postgresql.xql	4 Apr 2005 18:22:36 -0000	1.6
@@ -11,6 +11,7 @@
 		crr.item_id,
 		cri.storage_type,
 		crr.revision_id,
+		crr.content_length,
 		ets.mime_type
 		from evaluation_tasks_solsi ets, cr_items cri, cr_revisions crr
 		where ets.solution_id = :solution_id
@@ -31,20 +32,20 @@
       </querytext>
 </fullquery>
 
-<fullquery name="unassociate_task_sol">      
+<fullquery name="copy_content">      
       <querytext>
 
-	select evaluation__delete_task_sol(solution_id) 
-	from evaluation_tasks_sols 
-	where task_item_id = :task_item_id
-	    	
+		content_revision__content_copy(:solution_id, :revision_id)
+	
       </querytext>
 </fullquery>
 
-<fullquery name="copy_content">      
+<fullquery name="lob_content">      
       <querytext>
 
-		content_revision__content_copy(:solution_id, :revision_id)
+		update cr_revisions	
+	 	set lob = [set __lob_id [db_string get_lob_id "select empty_lob()"]]
+		where revision_id = :revision_id
 	
       </querytext>
 </fullquery>