From 72bdfabbad82960ddced40b66f867abb2afab0ac Mon Sep 17 00:00:00 2001 From: miker Date: Mon, 16 Mar 2009 19:40:11 +0000 Subject: [PATCH] incorrect table name in stored proc for updating materialized transaction summary git-svn-id: svn://svn.open-ils.org/ILS/trunk@12545 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Pg/080.schema.money.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/Open-ILS/src/sql/Pg/080.schema.money.sql b/Open-ILS/src/sql/Pg/080.schema.money.sql index b0fc53f9d6..4d83cfd34b 100644 --- a/Open-ILS/src/sql/Pg/080.schema.money.sql +++ b/Open-ILS/src/sql/Pg/080.schema.money.sql @@ -314,7 +314,7 @@ DECLARE BEGIN SELECT * INTO old_billing FROM money.billing WHERE xact = NEW.xact AND NOT voided ORDER BY billing_ts DESC LIMIT 1; - SELECT * INTO old_voided FROM money.payment_view WHERE xact = NEW.xact ORDER BY payment_ts DESC LIMIT 1; + SELECT * INTO old_voided FROM money.billing WHERE xact = NEW.xact ORDER BY billing_ts DESC LIMIT 1; IF NEW.voided AND NOT OLD.voided THEN IF OLD.id = old_voided.id THEN -- 2.11.0