Index: openacs-4/packages/notifications/sql/postgresql/upgrade/upgrade-4.6.2-4.6.4.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/notifications/sql/postgresql/upgrade/upgrade-4.6.2-4.6.4.sql,v
diff -u -r1.2 -r1.3
--- openacs-4/packages/notifications/sql/postgresql/upgrade/upgrade-4.6.2-4.6.4.sql	28 Aug 2003 09:41:58 -0000	1.2
+++ openacs-4/packages/notifications/sql/postgresql/upgrade/upgrade-4.6.2-4.6.4.sql	30 Mar 2013 18:50:28 -0000	1.3
@@ -24,28 +24,33 @@
 -- The define the new one
 select define_function_args ('notification__new','notification_id,type_id,object_id,notif_date,response_id,notif_user,notif_subject,notif_text,notif_html,creation_date,creation_user,creation_ip,context_id');
 
-create or replace function notification__new(integer,integer,integer,timestamptz,integer,integer,varchar,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_creation_date                 alias for $10;
-    p_creation_user                 alias for $11;
-    p_creation_ip                   alias for $12;
-    p_context_id                    alias for $13;
+
+
+--
+-- procedure notification__new/13
+--
+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_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,
@@ -65,5 +70,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);
 
     return v_notification_id;
-end;
-' language 'plpgsql';
+END;
+
+$$ LANGUAGE plpgsql;