Index: openacs-4/packages/acs-subsite/sql/postgresql/user-profiles-drop.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/sql/postgresql/user-profiles-drop.sql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/acs-subsite/sql/postgresql/user-profiles-drop.sql	12 Apr 2001 04:00:44 -0000	1.1
+++ openacs-4/packages/acs-subsite/sql/postgresql/user-profiles-drop.sql	17 Apr 2001 04:10:06 -0000	1.2
@@ -6,12 +6,15 @@
 -- @cvs-id $Id$
 --
 
+drop view cc_users_of_package_id;
+drop view registered_users_of_package_id;
+drop view application_users;
+
+select acs_rel_type__drop_type('user_profile', 'f');
+select acs_rel_type__drop_role('application');
+
+select drop_package('user_profile');
+
 drop table user_profiles;
-drop package user_profile;
 
-begin
-  acs_rel_type.drop_type('user_profile');
-end;
-/
-show errors