Index: openacs-4/packages/workflow/tcl/workflow-procs-oracle.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/workflow/tcl/workflow-procs-oracle.xql,v
diff -u -r1.3 -r1.4
--- openacs-4/packages/workflow/tcl/workflow-procs-oracle.xql	30 Sep 2003 12:10:12 -0000	1.3
+++ openacs-4/packages/workflow/tcl/workflow-procs-oracle.xql	29 Oct 2003 10:47:12 -0000	1.4
@@ -2,6 +2,25 @@
 <queryset>
   <rdbms><type>oracle</type><version>8.1.6</version></rdbms>
 
+  <fullquery name="workflow::get_not_cached.workflow_info">
+    <querytext>
+      select w.workflow_id,
+             w.short_name,
+             w.pretty_name,
+             w.object_id,
+             w.package_key,
+             w.object_type,
+             a.short_name as initial_action,
+             a.action_id as initial_action_id
+      from   workflows w,
+             workflow_initial_action wia,
+             workflow_actions a
+      where  w.workflow_id = :workflow_id
+        and  wia.workflow_id = w.workflow_id (+)
+        and  a.action_id = wia.action_id (+)
+    </querytext>
+  </fullquery>
+
   <fullquery name="workflow::new.do_insert">
     <querytext>
         begin
Index: openacs-4/packages/workflow/tcl/workflow-procs-postgresql.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/workflow/tcl/workflow-procs-postgresql.xql,v
diff -u -r1.5 -r1.6
--- openacs-4/packages/workflow/tcl/workflow-procs-postgresql.xql	5 Mar 2003 17:18:10 -0000	1.5
+++ openacs-4/packages/workflow/tcl/workflow-procs-postgresql.xql	29 Oct 2003 10:47:12 -0000	1.6
@@ -2,6 +2,26 @@
 <queryset>
   <rdbms><type>postgresql</type><version>7.2</version></rdbms>
 
+  <fullquery name="workflow::get_not_cached.workflow_info">
+    <querytext>
+      select w.workflow_id,
+             w.short_name,
+             w.pretty_name,
+             w.object_id,
+             w.package_key,
+             w.object_type,
+             a.short_name as initial_action,
+             a.action_id as initial_action_id
+      from   workflows w left outer join
+             workflow_initial_action wia 
+               on (w.workflow_id = wia.workflow_id) left outer join
+             workflow_actions a 
+               on (a.action_id = wia.action_id)
+      where  w.workflow_id = :workflow_id
+    </querytext>
+  </fullquery>
+
+
   <fullquery name="workflow::new.do_insert">
     <querytext>
         select workflow__new (
Index: openacs-4/packages/workflow/tcl/workflow-procs.xql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/workflow/tcl/workflow-procs.xql,v
diff -u -r1.6 -r1.7
--- openacs-4/packages/workflow/tcl/workflow-procs.xql	5 Mar 2003 17:18:10 -0000	1.6
+++ openacs-4/packages/workflow/tcl/workflow-procs.xql	29 Oct 2003 10:47:12 -0000	1.7
@@ -16,25 +16,6 @@
     </querytext>
   </fullquery>
 
-  <fullquery name="workflow::get_not_cached.workflow_info">
-    <querytext>
-      select w.workflow_id,
-             w.short_name,
-             w.pretty_name,
-             w.object_id,
-             w.package_key,
-             w.object_type,
-             a.short_name as initial_action,
-             a.action_id as initial_action_id
-      from   workflows w,
-             workflow_initial_action wia,
-             workflow_actions a
-      where  w.workflow_id = :workflow_id
-        and  w.workflow_id = wia.workflow_id
-        and  a.action_id = wia.action_id
-    </querytext>
-  </fullquery>
-
   <fullquery name="workflow::get_not_cached.workflow_callbacks">
     <querytext>
       select impl.impl_id,