Fix new serial constraint upgrades collab/senator/serials-avoid-materialize-error
authorDan Wells <dbw2@calvin.edu>
Mon, 9 Apr 2012 21:59:55 +0000 (17:59 -0400)
committerDan Wells <dbw2@calvin.edu>
Mon, 9 Apr 2012 22:04:31 +0000 (18:04 -0400)
commit2e8e14df7a7a605c3941dcfaf2727606c5b48f9b
treebdc54c8c738a55b515704a52ad922eacb2d20751
parent5b22d4221633605d147e0099776735c12b9f671e
Fix new serial constraint upgrades

1. None of the upgrades so far have moved is_json() from the public
to the evergreen schema.  That's probably a separate issue, but it
should be safe to call it unqualified, and that's what the rest of
the upgrade file does, so we will too.

2. Add a specific SET CONSTRAINT to avoid deferred trigger problems
when ALTERing the table.

3. Make sure that the unwanted columns on materialized_holding_code
do not exist regardless of your upgrade path.

Signed-off-by: Dan Wells <dbw2@calvin.edu>
Open-ILS/src/sql/Pg/upgrade/XXXX.schema.serial-holding-code-constraint.sql
Open-ILS/src/sql/Pg/version-upgrade/2.1-2.2-upgrade-db.sql