Index: openacs-4/packages/categories/sql/oracle/category-synonym-package.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/categories/sql/oracle/category-synonym-package.sql,v
diff -u -r1.2.2.1 -r1.2.2.2
--- openacs-4/packages/categories/sql/oracle/category-synonym-package.sql	8 Feb 2005 15:52:28 -0000	1.2.2.1
+++ openacs-4/packages/categories/sql/oracle/category-synonym-package.sql	8 Feb 2005 16:00:27 -0000	1.2.2.2
@@ -268,7 +268,7 @@
 -- triggers for category synonyms
 -----
 
-create trigger ins_synonym_on_ins_transl_trg
+create or replace trigger ins_synonym_on_ins_transl_trg
 after insert on category_translations for each row
 declare
 	v_synonym_id	integer;
