From 260552f481a696ea8fe78ad5e8a556048fb2e509 Mon Sep 17 00:00:00 2001 From: Chris Sharp Date: Fri, 18 Mar 2022 10:07:46 -0400 Subject: [PATCH] fix acq view creation Signed-off-by: Chris Sharp --- Open-ILS/src/sql/Pg/example.reporter-extension.sql | 2 +- 1 file changed, 1 insertion(+), 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 6deebd9b1a..b2e2dce72d 100644 --- a/Open-ILS/src/sql/Pg/example.reporter-extension.sql +++ b/Open-ILS/src/sql/Pg/example.reporter-extension.sql @@ -437,7 +437,7 @@ CREATE OR REPLACE VIEW reporter.acq_invoice_summary_view AS LEFT OUTER JOIN actor.org_unit receiver ON (invoice.receiver = receiver.id) LEFT OUTER JOIN actor.usr closer ON (invoice.closed_by = closer.id); -CREATE VIEW reporter.acq_purchase_order_summary_view AS +CREATE OR REPLACE VIEW reporter.acq_purchase_order_summary_view AS SELECT po.id, po.owner, po.creator, -- 2.11.0