Index: openacs-4/packages/forums/sql/postgresql/forums-drop.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/forums/sql/postgresql/forums-drop.sql,v
diff -u -r1.2 -r1.2.8.1
--- openacs-4/packages/forums/sql/postgresql/forums-drop.sql	28 Aug 2003 09:41:54 -0000	1.2
+++ openacs-4/packages/forums/sql/postgresql/forums-drop.sql	8 Oct 2005 01:37:43 -0000	1.2.8.1
@@ -8,6 +8,9 @@
 -- lifted from Gilbert's UBB forums. Thanks Orchard Labs.
 --
 
+-- Search
+\i forums-sc-drop.sql
+
 -- notifications
 \i forums-notifications-sanitize.sql
 
@@ -21,6 +24,3 @@
 -- The basic forum constructs
 \i forums-forums-package-drop.sql
 \i forums-forums-drop.sql
-
--- Search
-\i forums-sc-drop.sql
Index: openacs-4/packages/forums/sql/postgresql/forums-messages-package-drop.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/forums/sql/postgresql/forums-messages-package-drop.sql,v
diff -u -r1.3 -r1.3.8.1
--- openacs-4/packages/forums/sql/postgresql/forums-messages-package-drop.sql	17 May 2003 10:42:08 -0000	1.3
+++ openacs-4/packages/forums/sql/postgresql/forums-messages-package-drop.sql	8 Oct 2005 01:37:43 -0000	1.3.8.1
@@ -11,7 +11,7 @@
 -- chunks lifted from Gilbert. Thanks Orchard Labs!
 --
 
-drop function forums_message__new (integer,varchar,integer,varchar,text,char,integer,timestamptz,varchar,integer,timestamptz,integer,varchar,integer);
+drop function forums_message__new (integer,varchar,integer,varchar,text,char,integer,varchar,integer,timestamptz,integer,varchar,integer);
 
 drop function forums_message__root_message_id (integer);
 
Index: openacs-4/packages/forums/sql/postgresql/forums-sc-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/forums/sql/postgresql/forums-sc-create.sql,v
diff -u -r1.5 -r1.5.2.1
--- openacs-4/packages/forums/sql/postgresql/forums-sc-create.sql	30 Apr 2004 06:57:07 -0000	1.5
+++ openacs-4/packages/forums/sql/postgresql/forums-sc-create.sql	8 Oct 2005 01:37:43 -0000	1.5.2.1
@@ -9,7 +9,7 @@
 -- change to the thread.
 
 create or replace function forums_message_search__itrg ()
-returns opaque as '
+returns trigger as '
 begin
     if new.parent_id is null then
         perform search_observer__enqueue(new.message_id,''INSERT'');
@@ -20,7 +20,7 @@
 end;' language 'plpgsql';
 
 create or replace function forums_message_search__dtrg ()
-returns opaque as '
+returns trigger as '
 declare
      v_root_message_id          forums_messages.message_id%TYPE;
 begin
@@ -39,7 +39,7 @@
 end;' language 'plpgsql';
 
 create or replace function forums_message_search__utrg ()
-returns opaque as '
+returns trigger as '
 begin
     perform search_observer__enqueue(forums_message__root_message_id (old.message_id),''UPDATE'');
     return old;
@@ -59,23 +59,23 @@
 
 -- forums_forums indexing trigger
 create or replace function forums_forums_search__itrg ()
-returns opaque as '
+returns trigger as '
 begin
     perform search_observer__enqueue(new.forum_id,''INSERT'');
 
     return new;
 end;' language 'plpgsql';
 
 create or replace function forums_forums_search__utrg ()
-returns opaque as '
+returns trigger as '
 begin
     perform search_observer__enqueue(new.forum_id,''UPDATE'');
 
     return new;
 end;' language 'plpgsql';
 
 create or replace function forums_forums_search__dtrg ()
-returns opaque as '
+returns trigger as '
 begin
     perform search_observer__enqueue(old.forum_id,''DELETE'');
 
Index: openacs-4/packages/forums/sql/postgresql/forums-sc-drop.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/forums/sql/postgresql/forums-sc-drop.sql,v
diff -u -r1.3 -r1.3.2.1
--- openacs-4/packages/forums/sql/postgresql/forums-sc-drop.sql	1 Apr 2004 20:03:53 -0000	1.3
+++ openacs-4/packages/forums/sql/postgresql/forums-sc-drop.sql	8 Oct 2005 01:37:43 -0000	1.3.2.1
@@ -6,11 +6,19 @@
 --
 -- Removes search support from news module.
 --
-
 drop trigger forums_message_search__itrg on forums_messages;
 drop trigger forums_message_search__dtrg on forums_messages;
 drop trigger forums_message_search__utrg on forums_messages;
 
 drop function forums_message_search__itrg ();
 drop function forums_message_search__dtrg ();
 drop function forums_message_search__utrg ();
+
+drop trigger forums_forums_search__itrg on forums_forums;
+drop trigger forums_forums_search__dtrg on forums_forums;
+drop trigger forums_forums_search__utrg on forums_forums;
+
+drop function forums_forums_search__itrg ();
+drop function forums_forums_search__dtrg ();
+drop function forums_forums_search__utrg ();
+