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 -r1.4.2.1 -r1.4.2.2 --- openacs-4/packages/faq/sql/postgresql/faq-sc-create.sql 14 Feb 2019 16:15:01 -0000 1.4.2.1 +++ openacs-4/packages/faq/sql/postgresql/faq-sc-create.sql 25 Oct 2020 18:34:05 -0000 1.4.2.2 @@ -7,23 +7,23 @@ -- create function faq_sc__itrg () -returns opaque as $$ +returns trigger as $$ begin perform search_observer__enqueue(new.entry_id,'INSERT'); return new; end; $$ language plpgsql; create function faq_sc__dtrg () -returns opaque as $$ +returns trigger as $$ begin perform search_observer__enqueue(old.entry_id,'DELETE'); return old; end; $$ language plpgsql; create function faq_sc__utrg () -returns opaque as $$ +returns trigger as $$ begin perform search_observer__enqueue(old.entry_id,'UPDATE'); return old;