Merge pull request #1862 from gilmoskowitz/i24559_xtlocks

issue #24559 - add cascade

diff --git a/enyo-client/database/source/wipe_views.sql b/enyo-client/database/source/wipe_views.sql
index b921575..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 || ';', ' ') 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'