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.1 -r1.1.2.2 --- openacs-4/packages/rss-support/sql/postgresql/upgrade/upgrade-0.4d1-0.4d2.sql 27 Jul 2009 19:48:49 -0000 1.1.2.1 +++ 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 @@ -1,10 +1,11 @@ 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_nn not null 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;