From: Gil Moskowitz <gmoskowitz@xtuple.com>
Date: Fri, 19 Sep 2014 15:39:47 +0000 (-0400)
Subject: fix problem with cascade dropping views before they're explicitly dropped
X-Git-Tag: v4.7.0-beta.2~10^2
X-Git-Url: http://git.roojs.org/?p=xtuple;a=commitdiff_plain;h=778d7f6d30e94aaff85447ffa8d3af70b03b1f04

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

diff --git a/enyo-client/database/source/wipe_views.sql b/enyo-client/database/source/wipe_views.sql
index 457f066a8..2116aecf2 100644
--- 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'