From 778d7f6d30e94aaff85447ffa8d3af70b03b1f04 Mon Sep 17 00:00:00 2001 From: Gil Moskowitz Date: Fri, 19 Sep 2014 11:39:47 -0400 Subject: [PATCH] fix problem with cascade dropping views before they're explicitly dropped --- enyo-client/database/source/wipe_views.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) 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' -- 2.39.2