Index: openacs-4/packages/assessment/sql/postgresql/assessment-collected-data-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/sql/postgresql/assessment-collected-data-create.sql,v
diff -u -r1.16 -r1.17
--- openacs-4/packages/assessment/sql/postgresql/assessment-collected-data-create.sql	4 Feb 2009 18:47:49 -0000	1.16
+++ openacs-4/packages/assessment/sql/postgresql/assessment-collected-data-create.sql	16 Apr 2009 12:31:11 -0000	1.17
@@ -196,7 +196,7 @@
 begin
 
 select title into v_choice_value
-from as_item_choices
+from as_item_choicesx
 where choice_id = NEW.choice_id;
 
 update as_item_data set choice_value = coalesce(choice_value,'''') || '' '' || coalesce(v_choice_value,'''') where item_data_id = new.item_data_id;