]> git.evergreen-ils.org Git - working/Evergreen.git/commit
LP#1289486: Remove blocking constraint from audit table
authorMike Rylander <mrylander@gmail.com>
Mon, 8 Jun 2015 21:30:52 +0000 (17:30 -0400)
committerDan Wells <dbw2@calvin.edu>
Wed, 10 Jun 2015 19:08:54 +0000 (15:08 -0400)
commit3144f4a5a3dd6e5bbd4b3a5e4d92058cf1890a95
tree09ee232b1bcef28cc88b55ddf4c17a19f1392e53
parentf2f651de27a5433a8d1e5e6d127dabc2de4f40e9
LP#1289486: Remove blocking constraint from audit table

The ACQ lineitem audit table was augmented with an fkey pointing
to the queued record that was related to the line item.  That's
bad because there are also triggers which attempt to manage that
table.  Hilarity ensues.  We should not have an fkey on an audit
table, so, we now remove that.

In order to test this, first attempt to delete an ACQ queue and
have that fail.  Apply the DB change, attempt again, and have it
succeed.

Signed-off-by: Mike Rylander <mrylander@gmail.com>
Signed-off-by: Dan Wells <dbw2@calvin.edu>
Open-ILS/src/sql/Pg/upgrade/XXXX.schema.drop-acq-audit-fkey.sql [new file with mode: 0644]