Index: openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.3.0d2-5.3.0d3.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/upgrade/Attic/upgrade-5.3.0d2-5.3.0d3.sql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.3.0d2-5.3.0d3.sql	16 Nov 2006 11:58:17 -0000	1.1
+++ openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.3.0d2-5.3.0d3.sql	9 Dec 2006 15:23:06 -0000	1.2
@@ -35,3 +35,7 @@
     return v_rel_id;
    
 end;' language 'plpgsql';
+
+-- fix package instance names in acs_objects in case of renames
+update acs_objects set title = s.instance_name from (select p.instance_name, p.package_id from acs_objects o, apm_packages p where o.object_id = p.package_id and p.instance_name <> o.title) as s where object_id = s.package_id;
+
