Index: openacs-4/packages/assessment/sql/postgresql/upgrade/upgrade-0.17-0.18.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/assessment/sql/postgresql/upgrade/upgrade-0.17-0.18.sql,v
diff -u -r1.1.2.1 -r1.1.2.2
--- openacs-4/packages/assessment/sql/postgresql/upgrade/upgrade-0.17-0.18.sql	14 Feb 2006 18:02:57 -0000	1.1.2.1
+++ openacs-4/packages/assessment/sql/postgresql/upgrade/upgrade-0.17-0.18.sql	21 Feb 2006 18:09:33 -0000	1.1.2.2
@@ -1,7 +1,20 @@
 -- upgrade the column size
 drop view as_assessmentsx;
 drop view as_assessmentsi;
-alter table as_assessments alter column entry_page type varchar(4000);
-alter table as_assessments alter column exit_page type varchar(4000);
-alter table as_assessments alter column return_url type varchar(4000);
+
+alter table as_assessments rename entry_page to entry_page_old;
+alter table as_assessments add entry_page varchar(4000);
+update as_assessments set entry_page = entry_page_old;
+alter table as_assessments drop entry_page_old;
+
+alter table as_assessments rename exit_page to exit_page_old;
+alter table as_assessments add exit_page varchar(4000);
+update as_assessments set exit_page = exit_page_old;
+alter table as_assessments drop exit_page_old;
+
+alter table as_assessments rename return_url to return_url_old;
+alter table as_assessments add return_url varchar(4000);
+update as_assessments set return_url = return_url_old;
+alter table as_assessments drop return_url_old;
+
 select content_type__refresh_view('as_assessments');
\ No newline at end of file