Index: openacs-4/packages/rss-support/sql/postgresql/upgrade/upgrade-0.4d1-0.4d2.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/rss-support/sql/postgresql/upgrade/upgrade-0.4d1-0.4d2.sql,v diff -u -N -r1.1.2.2 -r1.1.2.3 --- openacs-4/packages/rss-support/sql/postgresql/upgrade/upgrade-0.4d1-0.4d2.sql 30 Jul 2009 13:23:41 -0000 1.1.2.2 +++ openacs-4/packages/rss-support/sql/postgresql/upgrade/upgrade-0.4d1-0.4d2.sql 31 Jul 2009 15:21:19 -0000 1.1.2.3 @@ -1,11 +1 @@ -alter table rss_gen_subscrs rename column summary_context_id to old_summary_context_id; - -alter table rss_gen_subscrs add summary_context_id integer - constraint rss_gen_subscrs_context_id_fk references acs_objects(object_id); - -update rss_gen_subscrs -set summary_context_id = old_summary_context_id::integer; - -alter table rss_gen_subscrs drop column old_summary_context_id; - -alter table rss_gen_subscrs alter rss_gen_subscrs_context_id set not null; +alter table rss_gen_subscrs alter summary_context_id type integer using summary_context_id::integer;