Index: openacs-4/packages/acs-content-repository/sql/postgresql/content-type.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-content-repository/sql/postgresql/content-type.sql,v
diff -u -N -r1.53 -r1.54
--- openacs-4/packages/acs-content-repository/sql/postgresql/content-type.sql	12 Oct 2009 22:42:34 -0000	1.53
+++ openacs-4/packages/acs-content-repository/sql/postgresql/content-type.sql	27 Jan 2010 17:34:09 -0000	1.54
@@ -313,8 +313,8 @@
       execute ''drop rule '' || v_table_name || ''_r '' || ''on '' || v_table_name || ''i'';
     end if;
 
-    execute ''drop view '' || v_table_name || ''x'';
-    execute ''drop view '' || v_table_name || ''i'';
+    execute ''drop view '' || v_table_name || ''x cascade'';
+    execute ''drop view '' || v_table_name || ''i cascade'';
 
     execute ''drop table '' || v_table_name;
   end if;
@@ -817,7 +817,7 @@
   -- create the output view (excludes content columns to enable SELECT *)
 
   if table_exists(v_table_name || ''x'') then
-     execute ''drop view '' || v_table_name || ''x'';
+     execute ''drop view '' || v_table_name || ''x cascade'';
   end if;
 
   execute ''create view '' || v_table_name ||
