Index: openacs-4/packages/rss-support/sql/postgresql/rss-generation-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/rss-support/sql/postgresql/rss-generation-create.sql,v
diff -u -r1.4 -r1.5
--- openacs-4/packages/rss-support/sql/postgresql/rss-generation-create.sql	5 Nov 2001 04:13:17 -0000	1.4
+++ openacs-4/packages/rss-support/sql/postgresql/rss-generation-create.sql	7 Nov 2001 04:42:15 -0000	1.5
@@ -187,7 +187,7 @@
 		   where object_id = p_subscr_id;
 
 	delete from rss_gen_subscrs
-		   where note_id = p_subscr_id;
+		   where subscr_id = p_subscr_id;
 
 	raise NOTICE ''Deleting subscription...'';
 	PERFORM acs_object__delete(p_subscr_id);