fix problem with cascade dropping views before they're explicitly dropped

[xtuple] / enyo-client / database / source / wipe_views.sql

diff --git a/enyo-client/database/source/wipe_views.sql b/enyo-client/database/source/wipe_views.sql
index 457f066..2116aec 100644 (file)
--- a/enyo-client/database/source/wipe_views.sql
+++ b/enyo-client/database/source/wipe_views.sql
@@ -4,7 +4,7 @@ do $$
 declare
   sqlstring text;
 begin
-  select string_agg('drop view ' || t.oid::regclass || ' cascade;', ' ') into sqlstring
+  select string_agg('drop view if exists ' || t.oid::regclass || ' cascade;', ' ') into sqlstring
     from pg_class t
     join pg_namespace n on n.oid = relnamespace
    where relkind = 'v'