Index: openacs-4/packages/notifications/sql/postgresql/upgrade/upgrade-5.4.0d2-5.4.0d3.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/notifications/sql/postgresql/upgrade/upgrade-5.4.0d2-5.4.0d3.sql,v
diff -u -N -r1.1 -r1.2
--- openacs-4/packages/notifications/sql/postgresql/upgrade/upgrade-5.4.0d2-5.4.0d3.sql	27 Jun 2007 18:54:48 -0000	1.1
+++ openacs-4/packages/notifications/sql/postgresql/upgrade/upgrade-5.4.0d2-5.4.0d3.sql	30 Mar 2013 18:50:28 -0000	1.2
@@ -3,29 +3,34 @@
 
 select define_function_args ('notification__new','notification_id,type_id,object_id,notif_date,response_id,notif_user,notif_subject,notif_text,notif_html,file_ids,creation_date,creation_user,creation_ip,context_id');
 
-create or replace function notification__new(integer,integer,integer,timestamptz,integer,integer,varchar,text,text,text,timestamptz,integer,varchar,integer)
-returns integer as '
-declare
-    p_notification_id               alias for $1;
-    p_type_id                       alias for $2;
-    p_object_id                     alias for $3;
-    p_notif_date                    alias for $4;
-    p_response_id                   alias for $5;
-    p_notif_user                    alias for $6;
-    p_notif_subject                 alias for $7;
-    p_notif_text                    alias for $8;
-    p_notif_html                    alias for $9;
-    p_file_ids                      alias for $10;
-    p_creation_date                 alias for $11;
-    p_creation_user                 alias for $12;
-    p_creation_ip                   alias for $13;
-    p_context_id                    alias for $14;
+
+
+--
+-- procedure notification__new/14
+--
+CREATE OR REPLACE FUNCTION notification__new(
+   p_notification_id integer,
+   p_type_id integer,
+   p_object_id integer,
+   p_notif_date timestamptz,
+   p_response_id integer,
+   p_notif_user integer,
+   p_notif_subject varchar,
+   p_notif_text text,
+   p_notif_html text,
+   p_file_ids text,
+   p_creation_date timestamptz,
+   p_creation_user integer,
+   p_creation_ip varchar,
+   p_context_id integer
+) RETURNS integer AS $$
+DECLARE
     v_notification_id               integer;
     v_notif_date                    notifications.notif_date%TYPE;
-begin
+BEGIN
     v_notification_id := acs_object__new(
         p_notification_id,
-        ''notification'',
+        'notification',
         p_creation_date,
         p_creation_user,
         p_creation_ip,
@@ -45,5 +50,6 @@
     (v_notification_id, p_type_id, p_object_id, v_notif_date, p_response_id, p_notif_user, p_notif_subject, p_notif_text, p_notif_html, p_file_ids);
 
     return v_notification_id;
-end;
-' language 'plpgsql';
+END;
+
+$$ LANGUAGE plpgsql;