Index: openacs-4/packages/assessment/sql/postgresql/upgrade/upgrade-0.22d5-0.22d6.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/sql/postgresql/upgrade/upgrade-0.22d5-0.22d6.sql,v diff -u -N -r1.2 -r1.3 --- openacs-4/packages/assessment/sql/postgresql/upgrade/upgrade-0.22d5-0.22d6.sql 2 Sep 2008 01:08:46 -0000 1.2 +++ openacs-4/packages/assessment/sql/postgresql/upgrade/upgrade-0.22d5-0.22d6.sql 7 Sep 2008 21:22:15 -0000 1.3 @@ -16,7 +16,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;