From a8d52041c82ae2c3c261fd321b711559d076d576 Mon Sep 17 00:00:00 2001 From: miker Date: Mon, 12 Oct 2009 16:20:20 +0000 Subject: [PATCH] forward porting 14363 and 14364: do not use NEW in an ON DELETE trigger, use OLD git-svn-id: svn://svn.open-ils.org/ILS/branches/rel_1_6_0@14365 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/src/sql/Pg/080.schema.money.sql | 2 +- Open-ILS/src/sql/Pg/1.4.0.5-1.6.0.0-upgrade-db.sql | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) diff --git a/Open-ILS/src/sql/Pg/080.schema.money.sql b/Open-ILS/src/sql/Pg/080.schema.money.sql index 8082c41cf5..5b46f9c3ef 100644 --- a/Open-ILS/src/sql/Pg/080.schema.money.sql +++ b/Open-ILS/src/sql/Pg/080.schema.money.sql @@ -370,7 +370,7 @@ BEGIN SET last_billing_ts = prev_billing.billing_ts, last_billing_note = prev_billing.note, last_billing_type = prev_billing.billing_type - WHERE id = NEW.xact; + WHERE id = OLD.xact; END IF; IF NOT OLD.voided THEN diff --git a/Open-ILS/src/sql/Pg/1.4.0.5-1.6.0.0-upgrade-db.sql b/Open-ILS/src/sql/Pg/1.4.0.5-1.6.0.0-upgrade-db.sql index 6de1355446..9cefa0db49 100644 --- a/Open-ILS/src/sql/Pg/1.4.0.5-1.6.0.0-upgrade-db.sql +++ b/Open-ILS/src/sql/Pg/1.4.0.5-1.6.0.0-upgrade-db.sql @@ -941,7 +941,7 @@ BEGIN SET last_billing_ts = prev_billing.billing_ts, last_billing_note = prev_billing.note, last_billing_type = prev_billing.billing_type - WHERE id = NEW.xact; + WHERE id = OLD.xact; END IF; IF NOT OLD.voided THEN -- 2.11.0