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 -N -r1.2 -r1.3
--- openacs-4/packages/lars-blogger/sql/postgresql/upgrade/upgrade-2.0d2-2.0d3.sql	17 May 2004 15:15:19 -0000	1.2
+++ openacs-4/packages/lars-blogger/sql/postgresql/upgrade/upgrade-2.0d2-2.0d3.sql	13 Jan 2005 13:58:21 -0000	1.3
@@ -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();