Index: openacs-4/contrib/obsolete-packages/acs-workflow/sql/postgresql/workflow-case-package.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/contrib/obsolete-packages/acs-workflow/sql/postgresql/workflow-case-package.sql,v
diff -u -r1.9 -r1.10
--- openacs-4/contrib/obsolete-packages/acs-workflow/sql/postgresql/workflow-case-package.sql	14 May 2001 23:16:08 -0000	1.9
+++ openacs-4/contrib/obsolete-packages/acs-workflow/sql/postgresql/workflow-case-package.sql	15 May 2001 05:09:08 -0000	1.10
@@ -953,7 +953,7 @@
                 quote_literal(evaluate_guard__transition_key) || '','' || 
                 quote_literal(evaluate_guard__place_key) || '','' || 
                 quote_literal(evaluate_guard__direction) || '','' || 
-                quote_literal(evaluate_guard__custom_arg) || '') as guard_happy_p'';
+                coalesce(quote_literal(evaluate_guard__custom_arg),''null'') || '') as guard_happy_p'';
                 for v_rec in 
                     execute v_str
                 LOOP
@@ -1539,6 +1539,7 @@
   v_subject                               text; 
   v_body                                  text; 
   v_request_id                            integer;       
+  v_str                                   text;
 begin
         select to_char(ta.deadline,''Mon fmDDfm, YYYY HH24:MI:SS''),
                acs_object__name(c.object_id),
@@ -1579,14 +1580,15 @@
         -- FIXME: last three args are also out varibles.
 
         if notify_assignee__callback != '''' and notify_assignee__callback is not null then
-            execute ''select '' || notify_assignee__callback || ''('' || 
+            v_str :=  ''select '' || notify_assignee__callback || ''('' || 
             notify_assignee__task_id || '','' ||
             coalesce(quote_literal(notify_assignee__custom_arg),''null'') || 
             '','' ||
             notify_assignee__user_id || '','' ||
             v_party_from || '','' ||
             quote_literal(v_subject) || '','' ||
             quote_literal(v_body) || '')'';
+            execute v_str;
         end if;
             
         -- FIXME: notifications package not ported yet.
