projects / evergreen / equinox.git / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 82a6569) | patch
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
tree93321e714b022de834d5edc594a629c9538872a8tree
parent82a656943c6ac116e74847149c03b363c5744962commit | diff
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 diff | blob | history
Evergreen working repo (Equinox)