Index: openacs-4/packages/search/sql/postgresql/search-tables-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/search/sql/postgresql/search-tables-create.sql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/search/sql/postgresql/search-tables-create.sql	2 Sep 2001 18:11:39 -0000	1.1
+++ openacs-4/packages/search/sql/postgresql/search-tables-create.sql	7 Sep 2001 03:01:57 -0000	1.2
@@ -1,7 +1,7 @@
 create table search_observer_queue (
     object_id		   integer
 			   constraint search_observer_queue_object_id_fk 
-			   references acs_objects(object_id),
+			   references acs_objects(object_id) on delete cascade,
     date		   timestamp default now(),
     event		   varchar(6)
 			   constraint search_observer_queue_event_ck