Index: openacs-4/packages/workflow/sql/postgresql/workflow-tables-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/workflow/sql/postgresql/workflow-tables-create.sql,v diff -u -r1.12 -r1.13 --- openacs-4/packages/workflow/sql/postgresql/workflow-tables-create.sql 28 Sep 2003 01:24:27 -0000 1.12 +++ openacs-4/packages/workflow/sql/postgresql/workflow-tables-create.sql 3 Oct 2003 10:12:46 -0000 1.13 @@ -533,7 +533,7 @@ -- Useful views ----------------- -create or replace view workflow_case_assigned_actions as +create view workflow_case_assigned_actions as select c.workflow_id, c.case_id, c.object_id, Index: openacs-4/packages/workflow/sql/postgresql/workflow-tables-drop.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/workflow/sql/postgresql/workflow-tables-drop.sql,v diff -u -r1.7 -r1.8 --- openacs-4/packages/workflow/sql/postgresql/workflow-tables-drop.sql 1 Sep 2003 13:43:51 -0000 1.7 +++ openacs-4/packages/workflow/sql/postgresql/workflow-tables-drop.sql 3 Oct 2003 10:12:46 -0000 1.8 @@ -36,6 +36,7 @@ drop function inline_0(); -- Drop all tables +drop view workflow_case_assigned_actions; drop table workflow_case_fsm; drop view workflow_case_role_user_map; drop table workflow_deputies;