Index: openacs-4/packages/acs-messaging/sql/postgresql/acs-messaging-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-messaging/sql/postgresql/acs-messaging-create.sql,v
diff -u -r1.10 -r1.10.2.1
--- openacs-4/packages/acs-messaging/sql/postgresql/acs-messaging-create.sql	17 May 2003 09:54:26 -0000	1.10
+++ openacs-4/packages/acs-messaging/sql/postgresql/acs-messaging-create.sql	24 Nov 2003 17:25:16 -0000	1.10.2.1
@@ -95,14 +95,14 @@
 
 -- support for tree queries on acs_messages
 
-create function acs_message_get_tree_sortkey(integer) returns varbit as '
+create or replace function acs_message_get_tree_sortkey(integer) returns varbit as '
 declare
   p_message_id    alias for $1;
 begin
   return tree_sortkey from acs_messages where message_id = p_message_id;
-end;' language 'plpgsql';
+end;' language 'plpgsql' stable strict;
 
-create function acs_message_insert_tr () returns opaque as '
+create or replace function acs_message_insert_tr () returns opaque as '
 declare
         v_parent_sk     varbit  default null;
         v_max_value     integer;
