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.78 -r1.79
--- openacs-4/packages/acs-kernel/acs-kernel.info	27 Feb 2005 19:45:54 -0000	1.78
+++ openacs-4/packages/acs-kernel/acs-kernel.info	6 Mar 2005 19:09:41 -0000	1.79
@@ -7,7 +7,7 @@
     <initial-install-p>t</initial-install-p>
     <singleton-p>t</singleton-p>
     
-    <version name="5.2.0d8" url="http://openacs.org/repository/download/apm/acs-kernel-5.2.0d8.apm">
+    <version name="5.2.0d9" url="http://openacs.org/repository/download/apm/acs-kernel-5.2.0d9.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>2005-01-09</release-date>
@@ -16,7 +16,7 @@
         <license>GPL</license>
         <maturity>3</maturity>
 
-        <provides url="acs-kernel" version="5.2.0d8"/>
+        <provides url="acs-kernel" version="5.2.0d9"/>
 
         <callbacks>
         </callbacks>
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.36 -r1.37
--- openacs-4/packages/acs-kernel/sql/postgresql/postgresql.sql	24 Jul 2004 14:44:55 -0000	1.36
+++ openacs-4/packages/acs-kernel/sql/postgresql/postgresql.sql	6 Mar 2005 19:09:41 -0000	1.37
@@ -157,7 +157,7 @@
                    order by proname 
         LOOP
             raise NOTICE ''DROPPING FUNCTION: %'', v_rec.proname;
-            v_drop_cmd := get_func_drop_command (v_rec.proname);
+            v_drop_cmd := get_func_drop_command (v_rec.proname::varchar);
             EXECUTE v_drop_cmd;
         end loop;
 
Index: openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.2.0d8-5.2.0d9.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.2.0d8-5.2.0d9.sql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.2.0d8-5.2.0d9.sql	6 Mar 2005 19:09:41 -0000	1.1
@@ -0,0 +1,30 @@
+-- on pg8 the get_func_drop_command is not found since it wont coerce proname to varchar
+create or replace function drop_package (varchar) returns varchar as '
+declare
+       package_name      alias for $1;
+       v_rec             record;
+       v_drop_cmd        varchar;
+       v_pkg_name        varchar;
+begin
+        raise NOTICE ''DROP PACKAGE: %'', package_name;
+        v_pkg_name := package_name || ''\\\\_\\\\_'' || ''%'';
+
+        for v_rec in select proname 
+                       from pg_proc 
+                      where proname like v_pkg_name 
+                   order by proname 
+        LOOP
+            raise NOTICE ''DROPPING FUNCTION: %'', v_rec.proname;
+            v_drop_cmd := get_func_drop_command (v_rec.proname::varchar);
+            EXECUTE v_drop_cmd;
+        end loop;
+
+        if NOT FOUND then 
+          raise NOTICE ''PACKAGE: % NOT FOUND'', package_name;
+        else
+          raise NOTICE ''PACKAGE: %: DROPPED'', package_name;
+        end if;
+        
+        return null;
+
+end;' language 'plpgsql';