Index: openacs-4/packages/faq/sql/postgresql/faq-sc-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/faq/sql/postgresql/faq-sc-create.sql,v
diff -u -N
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/faq/sql/postgresql/faq-sc-create.sql	7 Oct 2007 22:37:00 -0000	1.2
@@ -0,0 +1,38 @@
+-- 
+-- packages/faq/sql/postgresql/faq-sc-create.sql
+-- 
+-- @author Emmanuelle Raffenne (eraffenne@dia.uned.es)
+-- @creation-date 2007-07-11
+-- @arch-tag: 24e3ba57-1575-4718-b664-924e7bc170e1
+-- @cvs-id $Id: faq-sc-create.sql,v 1.2 2007/10/07 22:37:00 donb Exp $
+--
+
+create function faq_sc__itrg ()
+returns opaque as '
+    begin
+    perform search_observer__enqueue(new.entry_id,''INSERT''); 
+    return new;
+    end; ' 
+language 'plpgsql';
+
+create function faq_sc__dtrg ()
+returns opaque as '
+    begin
+    perform search_observer__enqueue(old.entry_id,''DELETE''); 
+    return old;
+    end; ' 
+language 'plpgsql';
+
+create function faq_sc__utrg ()
+returns opaque as '
+    begin
+    perform search_observer__enqueue(old.entry_id,''UPDATE''); 
+    return old;
+    end; ' 
+language 'plpgsql';
+
+create trigger faq_sc__itrg after insert on faq_q_and_as for each row execute procedure faq_sc__itrg ();
+
+create trigger faq_sc__dtrg after delete on faq_q_and_as for each row execute procedure faq_sc__dtrg ();
+
+create trigger faq_sc__utrg after update on faq_q_and_as for each row execute procedure faq_sc__utrg ();