Index: openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.0d7-5.0d9.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.0d7-5.0d9.sql,v diff -u -r1.3 -r1.4 --- openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.0d7-5.0d9.sql 25 Sep 2003 08:59:01 -0000 1.3 +++ openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-5.0d7-5.0d9.sql 30 Sep 2003 09:45:27 -0000 1.4 @@ -4,11 +4,12 @@ -- *** Remove a column not needed -- See http://openacs.org/bugtracker/openacs/bug?bug%5fnumber=555 -alter table apm_packages drop enabled_p; +-- Seems PG 7.2 doesn't support this +-- alter table apm_packages drop enabled_p; -- *** Get rid of file-related data no longer used -drop table apm_package_file_types cascade; -drop table apm_package_files cascade; +drop table apm_package_file_types; +drop table apm_package_files; -- View was dropped by previous drop --drop view apm_file_info; drop function apm_package_version__add_file (integer,integer,varchar,varchar, varchar);