X-Git-Url: http://git.roojs.org/?a=blobdiff_plain;f=enyo-client%2Fdatabase%2Fsource%2Fwipe_views.sql;h=2116aecf22f248568126d31e12745a4e388d029f;hb=778d7f6d30e94aaff85447ffa8d3af70b03b1f04;hp=457f066a84cfbbb5be2b26d789af4914f0ef09a5;hpb=cdeb004d516d8c5363a4014a85a0d19a1e3b7836;p=xtuple 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'