1 --Upgrade Script for 2.9.1 to 2.9.2
2 \set eg_version '''2.9.2'''
4 INSERT INTO config.upgrade_log (version, applied_to) VALUES ('2.9.2', :eg_version);
6 SELECT evergreen.upgrade_deps_block_check('0950', :eg_version);
8 CREATE OR REPLACE FUNCTION money.materialized_summary_billing_del () RETURNS TRIGGER AS $$
10 prev_billing money.billing%ROWTYPE;
11 old_billing money.billing%ROWTYPE;
13 SELECT * INTO prev_billing FROM money.billing WHERE xact = OLD.xact AND NOT voided ORDER BY billing_ts DESC LIMIT 1 OFFSET 1;
14 SELECT * INTO old_billing FROM money.billing WHERE xact = OLD.xact AND NOT voided ORDER BY billing_ts DESC LIMIT 1;
16 IF OLD.id = old_billing.id THEN
17 UPDATE money.materialized_billable_xact_summary
18 SET last_billing_ts = prev_billing.billing_ts,
19 last_billing_note = prev_billing.note,
20 last_billing_type = prev_billing.billing_type
24 IF NOT OLD.voided THEN
25 UPDATE money.materialized_billable_xact_summary
26 SET total_owed = total_owed - OLD.amount,
27 balance_owed = balance_owed - OLD.amount