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:53:25 +0000 (17:53 -0400)
commit0c159dff820720fb560dcf88ab8cdb0aab2b27b6
tree93321e714b022de834d5edc594a629c9538872a8
parent82a656943c6ac116e74847149c03b363c5744962
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