From 4bbd5baccf117cf8cde87e974d07c0b278b8b989 Mon Sep 17 00:00:00 2001 From: Chris Sharp Date: Thu, 8 Sep 2016 09:58:27 -0400 Subject: [PATCH] Adding logic to drop the view if exists. Signed-off-by: Chris Sharp --- Open-ILS/src/sql/Pg/upgrade/XXXX.schema.acq_po_and_invoice_views.sql | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.acq_po_and_invoice_views.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.acq_po_and_invoice_views.sql index 2609cfa22e..8e03e603c1 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.acq_po_and_invoice_views.sql +++ b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.acq_po_and_invoice_views.sql @@ -1,6 +1,8 @@ BEGIN; -CREATE OR REPLACE VIEW reporter.acq_purchase_order_view AS +DROP VIEW IF EXISTS reporter.acq_purchase_order_view; + +CREATE VIEW reporter.acq_purchase_order_view AS SELECT po.id AS po_id, po.name AS po_name, po.order_date AS po_order_date, -- 2.11.0