Index: openacs-4/packages/download/sql/postgresql/upgrade/upgrade-5.2d3-5.2d4.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/download/sql/postgresql/upgrade/upgrade-5.2d3-5.2d4.sql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/download/sql/postgresql/upgrade/upgrade-5.2d3-5.2d4.sql	25 Jul 2015 17:58:28 -0000	1.1
+++ openacs-4/packages/download/sql/postgresql/upgrade/upgrade-5.2d3-5.2d4.sql	25 Jul 2015 18:12:57 -0000	1.2
@@ -1,4 +1,8 @@
-create or replace view download_repository_obj as
+-- "create or replace view download_repository_obj" led to ERROR:  cannot change name of view column "context_id" to "obj_title"
+-- so we drop the view an create it later
+
+drop view download_repository_obj;
+create view download_repository_obj as
 select repository_id, 
                  o.object_id, o.object_type, o.title as obj_title, o.package_id as obj_package_id, o.context_id,
                  o.security_inherit_p, o.creation_user, o.creation_date, o.creation_ip, o.last_modified, o.modifying_user,
@@ -12,7 +16,8 @@
 	   and i.item_id = o.object_id
 	   and r.revision_id = i.live_revision;
 
-create or replace view download_arch_revisions_obj as
+drop view  download_arch_revisions_obj;
+create view download_arch_revisions_obj as
 select dar.*, 
                           o.object_id, o.object_type, o.title as obj_title, o.package_id as obj_package_id, o.context_id,
                           o.security_inherit_p, o.creation_user, o.creation_date, o.creation_ip, o.last_modified, o.modifying_user,
