Index: openacs-4/contrib/obsolete-packages/acs-workflow/sql/postgresql/sample-article-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/acs-workflow/sql/postgresql/sample-article-create.sql,v
diff -u -r1.1 -r1.2
--- openacs-4/contrib/obsolete-packages/acs-workflow/sql/postgresql/sample-article-create.sql	12 Apr 2001 00:12:06 -0000	1.1
+++ openacs-4/contrib/obsolete-packages/acs-workflow/sql/postgresql/sample-article-create.sql	13 Apr 2001 00:29:01 -0000	1.2
@@ -151,13 +151,12 @@
     'default', 'article_wf', 'specification', 'wf_callback.time_sysdate_plus_x', 1/24
 );
 
-commit;
 
 
 -- create or replace package wf_article_callback
 -- is
 --     procedure notification(
---         task_id 	in number, 
+--         task_id 	in integer, 
 --             custom_arg 	in varchar2, 
 --             party_to 	in integer, 
 --             party_from 	in out integer, 
@@ -174,7 +173,7 @@
 
 -- FIXME: last three variables are in/out variables.
 
-create function notification(number,varchar,integer,integer,varchar,varchar)
+create function notification(integer,varchar,integer,integer,varchar,varchar)
 returns integer as '
 declare
   notification__task_id               alias for $1; 	
@@ -188,7 +187,7 @@
   v_transition_name                   wf_transitions.transition_name%TYPE;
   v_name                              varchar(1000);
 begin
-        select to_char(ta.deadline,'Mon fmDDfm, YYYY HH24:MI:SS'),
+        select to_char(ta.deadline,''Mon fmDDfm, YYYY HH24:MI:SS''),
                acs_object.name(c.object_id),
                tr.transition_name
         into   v_deadline_pretty,
