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 -N -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 @@ postgresql7.2 + + + 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 + + + + select workflow__new (