Index: openacs-4/packages/acs-subsite/sql/postgresql/portraits-drop.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/sql/postgresql/portraits-drop.sql,v
diff -u -N -r1.1 -r1.2
--- openacs-4/packages/acs-subsite/sql/postgresql/portraits-drop.sql	12 Apr 2001 04:00:44 -0000	1.1
+++ openacs-4/packages/acs-subsite/sql/postgresql/portraits-drop.sql	17 Apr 2001 04:10:06 -0000	1.2
@@ -6,11 +6,8 @@
 -- @cvs-id $Id$
 --
 
-drop table user_portraits;
-drop package user_portrait_rel;
+select acs_rel_type__drop_type('user_portrait_rel', 'f');
+select acs_rel_type__drop_role('portrait');
+select acs_rel_type__drop_role('user');
 
-begin
-  acs_rel_type.drop_type('user_portrait_rel');
-end;
-/
-show errors
+drop table user_portraits;