Index: openacs-4/packages/lars-blogger/sql/postgresql/upgrade/upgrade-2.0d2-2.0d3.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/lars-blogger/sql/postgresql/upgrade/upgrade-2.0d2-2.0d3.sql,v
diff -u -r1.1.2.1 -r1.1.2.2
--- openacs-4/packages/lars-blogger/sql/postgresql/upgrade/upgrade-2.0d2-2.0d3.sql	25 Apr 2004 14:05:44 -0000	1.1.2.1
+++ openacs-4/packages/lars-blogger/sql/postgresql/upgrade/upgrade-2.0d2-2.0d3.sql	7 Sep 2004 16:25:51 -0000	1.1.2.2
@@ -1,5 +1,5 @@
-create function pinds_blog_entries__utrg ()
-returns opaque as '
+create function pinds_blog_entries__utrg()
+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'');
@@ -9,6 +9,6 @@
     return old;
 end;' language 'plpgsql';
 
-create or replace trigger pinds_blog_entries__utrg after update on pinds_blog_entries
-for each row execute procedure pinds_blog_entries__utrg ();
-
+create trigger pinds_blog_entries__utrg
+after update on pinds_blog_entries for each row execute
+procedure pinds_blog_entries__utrg();