Index: openacs-4/packages/news-aggregator/sql/postgresql/upgrade/upgrade-0.9d-0.9.4d.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/news-aggregator/sql/postgresql/upgrade/Attic/upgrade-0.9d-0.9.4d.sql,v diff -u -r1.1.2.1 -r1.1.2.2 --- openacs-4/packages/news-aggregator/sql/postgresql/upgrade/upgrade-0.9d-0.9.4d.sql 28 Dec 2005 17:55:43 -0000 1.1.2.1 +++ openacs-4/packages/news-aggregator/sql/postgresql/upgrade/upgrade-0.9d-0.9.4d.sql 28 Dec 2005 18:40:36 -0000 1.1.2.2 @@ -1,2 +1,2 @@ -alter table na_user_preferences add package_id constraint na_user_preferences_pid_fk references apm_packages(package_id); +alter table na_user_preferences add column package_id integer constraint na_user_preferences_pid_fk references apm_packages(package_id); alter table na_user_preferences drop constraint na_user_prefs_uid_pk;