Comment 8 for bug 1289486

Revision history for this message
Mike Rylander (mrylander) wrote :

The ultimate cause was a little more nuanced than my above comment suggests -- the foreign key that was causing the problem was actually part of an update, not part of the original table creation -- but find below a branch that removes the offending constraint. From the commit message:

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.

http://git.evergreen-ils.org/?p=working/Evergreen.git;a=shortlog;h=refs/heads/user/miker/lp1289486-acq-audit-tables-block-queue-delete