Index: openacs-4/packages/acs-messaging/sql/postgresql/acs-messaging-packages.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-messaging/sql/postgresql/acs-messaging-packages.sql,v
diff -u -r1.12 -r1.13
--- openacs-4/packages/acs-messaging/sql/postgresql/acs-messaging-packages.sql	17 May 2003 09:54:26 -0000	1.12
+++ openacs-4/packages/acs-messaging/sql/postgresql/acs-messaging-packages.sql	28 Aug 2003 09:41:39 -0000	1.13
@@ -10,7 +10,7 @@
 -- updated for OpenACS by Jon Griffin
 --
 
-create function acs_message__edit (integer,varchar,varchar,varchar,text,integer,timestamptz,integer,varchar,boolean)
+create or replace function acs_message__edit (integer,varchar,varchar,varchar,text,integer,timestamptz,integer,varchar,boolean)
 returns integer as '
 declare
     p_message_id    alias for $1;
@@ -73,7 +73,7 @@
 -- Jon Griffin 05-21-2001
 ----------------
 
-create function acs_message__new (integer,integer,timestamptz,integer,
+create or replace function acs_message__new (integer,integer,timestamptz,integer,
 varchar,varchar,varchar,varchar,text,integer,integer,integer,integer,
 varchar,varchar,boolean)
 returns integer as '
@@ -167,7 +167,7 @@
         return v_message_id;
 end;' language 'plpgsql';
 
-create function acs_message__delete (integer)
+create or replace function acs_message__delete (integer)
 returns integer as '
 declare
     p_message_id    alias for $1;
@@ -177,7 +177,7 @@
     return 1;
 end;' language 'plpgsql';
 
-create function acs_message__message_p (integer)
+create or replace function acs_message__message_p (integer)
 returns boolean as '
 declare
     p_message_id          alias for $1;
@@ -193,7 +193,7 @@
     end if;
 end;' language 'plpgsql';
 
-create function acs_message__send (integer,varchar,integer,timestamptz)
+create or replace function acs_message__send (integer,varchar,integer,timestamptz)
 returns integer as '
 declare
     p_message_id    alias for $1;
@@ -210,7 +210,7 @@
     return 1;
 end;' language 'plpgsql';
 
-create function acs_message__send (integer,integer,integer,timestamptz)
+create or replace function acs_message__send (integer,integer,integer,timestamptz)
 returns integer as '
 declare
     p_message_id    alias for $1;
@@ -231,7 +231,7 @@
 
 -- Ported to take advantage of tree_sortkey column by DLP
 
-create function acs_message__first_ancestor (integer)
+create or replace function acs_message__first_ancestor (integer)
 returns integer as '
 declare
     p_message_id alias for $1;
@@ -256,7 +256,7 @@
     -- functions will migrate to another PL/SQL package or be replaced
     -- by direct calls to CR code in the near future.
 
-create function acs_message__new_file (integer,integer,varchar,varchar,
+create or replace function acs_message__new_file (integer,integer,varchar,varchar,
 text,varchar,integer,timestamptz,integer,varchar,boolean,varchar)
 returns integer as '
 declare
@@ -310,7 +310,7 @@
     return v_file_id;
 end;' language 'plpgsql';
 
-create function acs_message__edit_file (integer,varchar,text,varchar,
+create or replace function acs_message__edit_file (integer,varchar,text,varchar,
 integer,timestamptz,integer,varchar,boolean)
 returns integer as '
 declare
@@ -347,7 +347,7 @@
     return v_revision_id;
 end;' language 'plpgsql';
 
-create function acs_message__delete_file (integer)
+create or replace function acs_message__delete_file (integer)
 returns integer as '
 declare
     p_file_id  alias for $1;
@@ -356,7 +356,7 @@
     return 1;
 end;' language 'plpgsql';
 
-create function acs_message__new_image (integer,integer,varchar,varchar,
+create or replace function acs_message__new_image (integer,integer,varchar,varchar,
 text,varchar,integer,integer,integer,timestamptz,integer,varchar,boolean,varchar)
 returns integer as '
 declare
@@ -414,7 +414,7 @@
     return v_image_id;
 end;' language 'plpgsql';
 
-create function acs_message__edit_image (integer,varchar,text,varchar,
+create or replace function acs_message__edit_image (integer,varchar,text,varchar,
 integer,integer,integer,timestamptz,integer,varchar,boolean)
 returns integer as '
 declare
@@ -461,7 +461,7 @@
     return v_revision_id;
 end;' language 'plpgsql';
 
-create function acs_message__delete_image (integer)
+create or replace function acs_message__delete_image (integer)
 returns integer as '
 declare
     p_image_id  alias for $1;
@@ -474,7 +474,7 @@
 end;' language 'plpgsql';
 
     -- XXX should just call content_extlink.new
-create function acs_message__new_extlink (varchar,integer,varchar,
+create or replace function acs_message__new_extlink (varchar,integer,varchar,
 varchar,text,integer,timestamptz,integer,varchar)
 returns integer as '
 declare
@@ -505,7 +505,7 @@
 end;' language 'plpgsql';
     
 -- XXX should just edit extlink
-create function acs_message__edit_extlink (integer,varchar,varchar,text)
+create or replace function acs_message__edit_extlink (integer,varchar,varchar,text)
 returns integer as '
 declare
     p_extlink_id   alias for $1;
@@ -525,7 +525,7 @@
     return 0;
 end;' language 'plpgsql';
 
-create function acs_message__delete_extlink (integer)
+create or replace function acs_message__delete_extlink (integer)
 returns integer as '
 declare
     p_extlink_id    alias for $1;
@@ -535,7 +535,7 @@
 	return 0;
 end;' language 'plpgsql';
 
-create function acs_message__name (integer)
+create or replace function acs_message__name (integer)
 returns varchar as '
 declare
     p_message_id   alias for $1;
