Index: openacs-4/packages/acs-kernel/sql/postgresql/rel-segments-body-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/rel-segments-body-create.sql,v
diff -u -r1.7 -r1.8
--- openacs-4/packages/acs-kernel/sql/postgresql/rel-segments-body-create.sql	2 Jul 2002 21:16:06 -0000	1.7
+++ openacs-4/packages/acs-kernel/sql/postgresql/rel-segments-body-create.sql	8 Jul 2002 22:09:32 -0000	1.8
@@ -50,10 +50,14 @@
 declare
   new__segment_name      alias for $1;  
   new__group_id          alias for $2;  
-  new__rel_type          alias for $3; 
+  new__rel_type          alias for $3;
+  v_segment_id           rel_segments.segment_id%TYPE;
 begin
-	return rel_segment__new(null, ''rel_segment'', now(), null, null, null, null new__segment_name, new__group_id, new_rel_type, null);
 
+   v_segment_id := rel_segment__new(null, ''rel_segment'', now(), null, null, null, null, new__segment_name, new__group_id, new__rel_type, null);
+
+   return v_segment_id;
+
 end;' language 'plpgsql';
 
 
Index: openacs-4/packages/dotlrn/sql/oracle/dotlrn-init.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/sql/oracle/dotlrn-init.sql,v
diff -u -r1.27 -r1.28
--- openacs-4/packages/dotlrn/sql/oracle/dotlrn-init.sql	13 Jun 2002 04:34:56 -0000	1.27
+++ openacs-4/packages/dotlrn/sql/oracle/dotlrn-init.sql	8 Jul 2002 22:10:21 -0000	1.28
@@ -290,7 +290,7 @@
         attribute_name => 'admin_pretty_name',
         datatype => 'string',
         pretty_name => 'Administrator Pretty Name',
-        pretty_plural => 'RAdministrator Pretty Name',
+        pretty_plural => 'Administrator Pretty Name',
         min_n_values => 0,
         max_n_values => 1,
         storage => 'generic'
Index: openacs-4/packages/user-profile/sql/postgresql/user-profile-package-drop.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/user-profile/sql/postgresql/user-profile-package-drop.sql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/user-profile/sql/postgresql/user-profile-package-drop.sql	29 Mar 2002 16:56:10 -0000	1.1
+++ openacs-4/packages/user-profile/sql/postgresql/user-profile-package-drop.sql	8 Jul 2002 22:10:21 -0000	1.2
@@ -5,7 +5,6 @@
 -- @version $Id$
 --
 
-drop function user_profile_rel__new(integer,varchar,integer,integer,integer,varchar);
+select drop_package('user_profile_rel');
 
-drop function user_profile_rel__delete(integer);
 
Index: openacs-4/packages/user-profile/sql/postgresql/user-profile-provider-drop.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/user-profile/sql/postgresql/user-profile-provider-drop.sql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/user-profile/sql/postgresql/user-profile-provider-drop.sql	29 Mar 2002 16:56:10 -0000	1.1
+++ openacs-4/packages/user-profile/sql/postgresql/user-profile-provider-drop.sql	8 Jul 2002 22:10:21 -0000	1.2
@@ -5,42 +5,51 @@
 -- @version $Id$
 --
 
+create function inline_0()
+returns integer as '
 begin
 
     -- drop the binding between this implementation and the interface it
     -- implements.
-    select acs_sc_binding__delete (
-        'profile_provider',
-        'user_profile_provider'
+    perform acs_sc_binding__delete (
+        ''profile_provider'',
+        ''user_profile_provider''
     );
 
     -- drop the bindings to the method implementations
 
     -- name method
-    select acs_sc_impl_alias__delete (
-        'profile_provider',
-        'user_profile_provider',
-        'name'
+    perform acs_sc_impl_alias__delete (
+        ''profile_provider'',
+        ''user_profile_provider'',
+        ''name''
     );
 
     -- prettyName method
-    select acs_sc_impl_alias__delete (
-        'profile_provider',
-        'user_profile_provider',
-        'prettyName'
+    perform acs_sc_impl_alias__delete (
+        ''profile_provider'',
+        ''user_profile_provider'',
+        ''prettyName''
     );
 
     -- render method
-    select acs_sc_impl_alias__delete (
-        'profile_provider',
-        'user_profile_provider',
-        'render'
+    perform acs_sc_impl_alias__delete (
+        ''profile_provider'',
+        ''user_profile_provider'',
+        ''render''
     );
 
     -- drop the implementation
-    select acs_sc_impl__delete(
-        'profile_provider',
-        'user_profile_provider'
+    perform acs_sc_impl__delete(
+        ''profile_provider'',
+        ''user_profile_provider''
     );
 
-end;
+    return 0;
+
+end;' language 'plpgsql';
+
+select inline_0();
+drop function inline_0();
+
+
Index: openacs-4/packages/user-profile/sql/postgresql/user-profile-sanitize.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/user-profile/sql/postgresql/user-profile-sanitize.sql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/user-profile/sql/postgresql/user-profile-sanitize.sql	29 Mar 2002 16:56:10 -0000	1.1
+++ openacs-4/packages/user-profile/sql/postgresql/user-profile-sanitize.sql	8 Jul 2002 22:10:21 -0000	1.2
@@ -31,11 +31,13 @@
         foo
     );
 
-    select acs_rel_type__drop_type(
+    perform acs_rel_type__drop_type(
         ''user_profile_rel'',
         ''t''
     );
 
+    return 0;
+
 end;
 ' language 'plpgsql';