LP#1289486: Remove blocking constraint from audit table user/miker/lp1289486-acq-audit-tables-block-queue-delete
authorMike Rylander <mrylander@gmail.com>
Mon, 8 Jun 2015 21:30:52 +0000 (17:30 -0400)
committerMike Rylander <mrylander@gmail.com>
Mon, 8 Jun 2015 21:39:18 +0000 (17:39 -0400)
commit913eb11db4f9ef31c5e359e8605a339d0c9c3017
tree7f148cc0562d5f8919cafef3f32d26facda44d01
parent6bb8ea5599d39d41d623d1891b3c509c4e439178
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>
Open-ILS/src/sql/Pg/upgrade/XXXX.schema.drop-acq-audit-fkey.sql [new file with mode: 0644]