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.6 -r1.7
--- openacs-4/packages/acs-messaging/sql/postgresql/acs-messaging-packages.sql	29 Aug 2001 18:46:37 -0000	1.6
+++ openacs-4/packages/acs-messaging/sql/postgresql/acs-messaging-packages.sql	19 Sep 2001 00:54:22 -0000	1.7
@@ -327,20 +327,23 @@
     p_is_live       alias for $9;    -- default ''t''
     v_revision_id  cr_revisions.revision_id%TYPE;
 begin
-		--hmmm not sure which function to use
     v_revision_id := content_revision__new (
         p_title,				-- title         
+        p_description,
+        current_timestamp,
         p_mime_type,			-- mime_type     
+        NULL,
         p_content,				-- data          
         p_file_id,				-- item_id       
+        NULL,
         p_creation_date,		-- creation_date 
         p_creation_user,		-- creation_user 
         p_creation_ip			-- creation_ip   
     );
 
     -- test for auto approval of revision
     if p_is_live = ''t'' then 
-        content_item__set_live_revision(v_revision_id);
+        perform content_item__set_live_revision(v_revision_id);
     end if;
 
     return v_revision_id;
@@ -533,7 +536,7 @@
 returns varchar as '
 declare
     p_message_id   alias for $1;
-    v_message_name   acs_messages_all.title%TYPE;
+    v_message_name   cr_revisions.title%TYPE;
 begin
     select title into v_message_name
         from acs_messages_all