Index: openacs-4/packages/acs-kernel/acs-kernel.info
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/acs-kernel.info,v
diff -u -r1.150.2.65 -r1.150.2.66
--- openacs-4/packages/acs-kernel/acs-kernel.info	30 Jul 2024 17:53:44 -0000	1.150.2.65
+++ openacs-4/packages/acs-kernel/acs-kernel.info	13 Aug 2024 07:52:33 -0000	1.150.2.66
@@ -9,15 +9,15 @@
     <implements-subsite-p>f</implements-subsite-p>
     <inherit-templates-p>t</inherit-templates-p>
 
-    <version name="5.10.1b5" url="http://openacs.org/repository/download/apm/acs-kernel-5.10.1b5.apm">
+    <version name="5.10.1b6" url="http://openacs.org/repository/download/apm/acs-kernel-5.10.1b6.apm">
         <owner url="mailto:oct@openacs.org">OpenACS Core Team</owner>
         <summary>Routines and data models providing the foundation for OpenACS-based Web services.</summary>
         <release-date>2023-07-10</release-date>
         <vendor url="http://openacs.org">OpenACS</vendor>
         <description format="text/html">The OpenACS kernel contains the core datamodel create and drop scripts for such things as objects, groups, parties and the supporting PL/SQL and PL/pgSQL procedures.</description>
         <maturity>3</maturity>
 
-        <provides url="acs-kernel" version="5.10.1b5"/>
+        <provides url="acs-kernel" version="5.10.1b6"/>
 
         <callbacks>
         </callbacks>
Index: openacs-4/packages/acs-kernel/sql/postgresql/community-core-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/community-core-create.sql,v
diff -u -r1.29.6.6 -r1.29.6.7
--- openacs-4/packages/acs-kernel/sql/postgresql/community-core-create.sql	28 Mar 2023 11:20:36 -0000	1.29.6.6
+++ openacs-4/packages/acs-kernel/sql/postgresql/community-core-create.sql	13 Aug 2024 07:52:33 -0000	1.29.6.7
@@ -764,15 +764,9 @@
 -- show errors
 
 -- create or replace package body acs_user
--- function new
-select define_function_args('user__new','user_id,object_type;user,creation_date;now(),creation_user,creation_ip,authority_id,username,email,url,first_names,last_name,password,salt,screen_name,email_verified_p;t,context_id');
 
+select define_function_args('acs_user__new','user_id;null,object_type;user,creation_date;now(),creation_user;null,creation_ip;null,authority_id;null,username,email,url;null,first_names,last_name,password,salt,screen_name;null,email_verified_p;t,context_id;null');
 
-
-
--- added
-select define_function_args('acs_user__new','user_id;null,object_type;user,creation_date;now(),creation_user;null,creation_ip;null,authority_id,username,email,url;null,first_names,last_name,password,salt,screen_name;null,email_verified_p;t,context_id;null');
-
 --
 -- procedure acs_user__new/16
 --
Index: openacs-4/packages/acs-kernel/sql/postgresql/postgresql.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/postgresql.sql,v
diff -u -r1.52 -r1.52.2.1
--- openacs-4/packages/acs-kernel/sql/postgresql/postgresql.sql	17 Dec 2018 09:13:47 -0000	1.52
+++ openacs-4/packages/acs-kernel/sql/postgresql/postgresql.sql	13 Aug 2024 07:52:33 -0000	1.52.2.1
@@ -195,6 +195,8 @@
             raise NOTICE 'DROPPING FUNCTION: %', v_rec.proname;
             v_drop_cmd := get_func_drop_command (v_rec.proname::varchar);
             EXECUTE v_drop_cmd;
+
+            DELETE FROM acs_function_args where function = upper(v_rec.proname);
         end loop;
 
         if NOT FOUND then 
Fisheye: Tag 1.1 refers to a dead (removed) revision in file `openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.10.1b5-5.10.1b6.sql'.
Fisheye: No comparison available.  Pass `N' to diff?