projects / working / Evergreen.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 3ecef49) | patch
LP 2009066: Set invoice_item_fund_debit_fkey Deferrable user/dyrcona/lp2009066-acq-invoice_item_fund_debit_fkey-deferred
authorJason Stephenson <jason@sigio.com>
Fri, 3 Mar 2023 20:53:17 +0000 (15:53 -0500)
committerJason Stephenson <jason@sigio.com>
Fri, 3 Mar 2023 20:57:32 +0000 (15:57 -0500)
commit57c709e6c35252a23c7f9c98f85a38e54ea2eae8
treeae521fb9c3e6c2510a9f4e0a31927e19fd925339tree
parent3ecef495d8268fdc966778e47309f326f32281e1commit | diff
LP 2009066: Set invoice_item_fund_debit_fkey Deferrable

Make the foreign key relationship between acq.invoice_item and
acq.fund_debit deferrable so that fund debits can be deleted in the
same transactions as the invoice items.  Otherwise, the fund debits
cannot be deleted if at all if referenced by an invoice item.

Signed-off-by: Jason Stephenson <jason@sigio.com>
Open-ILS/src/sql/Pg/200.schema.acq.sql diff | blob | history
Open-ILS/src/sql/Pg/upgrade/XXXX.schema.acq-invoice_item_fund_debit_fkey-deferrable.sql [new file with mode: 0644] blob
docs/RELEASE_NOTES_NEXT/miscellaneous.adoc diff | blob | history
Evergreen ILS