From f61f19305f72d5f1c17c1d0bb4a99b580eea8cc0 Mon Sep 17 00:00:00 2001 From: Chris Sharp Date: Thu, 8 Sep 2016 10:22:21 -0400 Subject: [PATCH] Adding DROP VIEW IF EXISTS statement to example reporter file. Signed-off-by: Chris Sharp --- Open-ILS/src/sql/Pg/example.reporter-extension.sql | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) diff --git a/Open-ILS/src/sql/Pg/example.reporter-extension.sql b/Open-ILS/src/sql/Pg/example.reporter-extension.sql index 2ac2f33d26..903e7d0368 100644 --- a/Open-ILS/src/sql/Pg/example.reporter-extension.sql +++ b/Open-ILS/src/sql/Pg/example.reporter-extension.sql @@ -316,7 +316,9 @@ CREATE OR REPLACE VIEW money.open_balance_by_usr_home_and_owning_lib AS FROM money.open_circ_balance_by_usr_home_and_owning_lib x GROUP BY 1,2; -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