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);
Index: openacs-4/packages/rss-support/sql/postgresql/rss-generation-drop.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/rss-support/sql/postgresql/rss-generation-drop.sql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/rss-support/sql/postgresql/rss-generation-drop.sql	5 Nov 2001 03:55:01 -0000	1.1
+++ openacs-4/packages/rss-support/sql/postgresql/rss-generation-drop.sql	7 Nov 2001 04:42:15 -0000	1.2
@@ -1,3 +1,3 @@
---
--- FIXME: write this file
---
\ No newline at end of file
+drop table rss_gen_subscrs;
+drop function rss_gen_subscr__new (integer);
+drop function rss_gen_subscr__delete (integer);
Index: openacs-4/packages/rss-support/sql/postgresql/rss-generation-sc-drop.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/rss-support/sql/postgresql/rss-generation-sc-drop.sql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/rss-support/sql/postgresql/rss-generation-sc-drop.sql	5 Nov 2001 03:55:01 -0000	1.1
+++ openacs-4/packages/rss-support/sql/postgresql/rss-generation-sc-drop.sql	7 Nov 2001 04:42:15 -0000	1.2
@@ -9,7 +9,3 @@
 
 select acs_sc_contract__delete('RssGenerationSubscriber');
 
-
-
-
-select acs_sc_msg_type__delete
\ No newline at end of file