Index: openacs-4/packages/lars-blogger/sql/postgresql/lars-blogger-sc-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/lars-blogger/sql/postgresql/lars-blogger-sc-create.sql,v diff -u -r1.3 -r1.4 --- openacs-4/packages/lars-blogger/sql/postgresql/lars-blogger-sc-create.sql 2 Apr 2004 01:01:08 -0000 1.3 +++ openacs-4/packages/lars-blogger/sql/postgresql/lars-blogger-sc-create.sql 25 Oct 2020 18:57:08 -0000 1.4 @@ -25,7 +25,7 @@ create function pinds_blog_entries__itrg () -returns opaque as ' +returns trigger as ' begin if new.draft_p = ''f'' then perform search_observer__enqueue(new.entry_id,''INSERT''); @@ -34,14 +34,14 @@ end;' language 'plpgsql'; create function pinds_blog_entries__dtrg () -returns opaque as ' +returns trigger as ' begin perform search_observer__enqueue(old.entry_id,''DELETE''); return old; end;' language 'plpgsql'; create function pinds_blog_entries__utrg () -returns opaque as ' +returns trigger as ' begin if (new.draft_p = ''t'' and old.draft_p = ''f'') or new.deleted_p = ''t'' then perform search_observer__enqueue(old.entry_id,''DELETE'');