Move authority.record_entry trigger changes out of transaction
authorDan Wells <dbw2@calvin.edu>
Wed, 14 May 2014 21:03:38 +0000 (17:03 -0400)
committerDan Wells <dbw2@calvin.edu>
Wed, 14 May 2014 21:54:16 +0000 (17:54 -0400)
commit5b6bde7bcceea46f982fe7d65bcc252182b16b5a
tree6b555490969de375dc6ba63cda345e515022213f
parent110f9e1c54da9b5f42b0ccfb9eee08d6acd89540
Move authority.record_entry trigger changes out of transaction

This should prevent 'cannot ALTER TABLE "record_entry" because it has
pending trigger events' errors.

This is the same approach used in the original 0875 script, but we
might also work around the problem with a well-placed
SET CONSTRAINTS ALL IMMEDIATE;

Signed-off-by: Dan Wells <dbw2@calvin.edu>
Open-ILS/src/sql/Pg/version-upgrade/2.5.3-2.6.0-upgrade-db.sql