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.2 -r1.2.4.1
--- openacs-4/packages/assessment/sql/postgresql/upgrade/upgrade-0.17-0.18.sql	12 Jun 2006 02:49:50 -0000	1.2
+++ openacs-4/packages/assessment/sql/postgresql/upgrade/upgrade-0.17-0.18.sql	1 Jun 2008 13:35:39 -0000	1.2.4.1
@@ -1,20 +1,18 @@
 -- upgrade the column size
-drop view as_assessmentsx;
-drop view as_assessmentsi;
 
 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 drop entry_page_old cascade;
 
 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 drop exit_page_old cascade;
 
 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;
+alter table as_assessments drop return_url_old cascade;
 
-select content_type__refresh_view('as_assessments');
\ No newline at end of file
+select content_type__refresh_view('as_assessments');
