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.3 -r1.4
--- openacs-4/packages/categories/sql/oracle/category-synonym-package.sql	6 Dec 2004 12:05:28 -0000	1.3
+++ openacs-4/packages/categories/sql/oracle/category-synonym-package.sql	24 Feb 2005 13:33:05 -0000	1.4
@@ -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;
@@ -284,7 +284,7 @@
 /
 show errors
 
-create trigger upd_synonym_on_upd_transl_trg
+create or replace trigger upd_synonym_on_upd_transl_trg
 before update on category_translations for each row
 declare
 	v_synonym_id	integer;
