2.8.4-2.9.0 DB upgrade script fails due to data vs. schema changes

[Chris Sharp]

When running Open-ILS/src/sql/Pg/version-upgrade/2.8.4-2.9.0-upgrade-db.sql, I get the following error:

psql:2.8.4-2.9.0-upgrade-db.sql:22204: ERROR: cannot ALTER TABLE "record_attr_definition" because it has pending trigger events

line 22203 and 22204 in that script:

ALTER TABLE config.record_attr_definition
    ADD COLUMN vocabulary TEXT;

Looks like we're going to have to separate another data update from the main script.

Evergreen 2.9.0
PostgreSQL 9.4
Ubuntu 14.04 LTS

[Jason Stephenson (jstephenson)]

I pushed a branch to working/user/dyrcona/lp1497307_fix_upgrade_script

http://git.evergreen-ils.org/?p=working/Evergreen.git;a=shortlog;h=refs/heads/user/dyrcona/lp1497307_fix_upgrade_script

[Chris Sharp (chrissharp123)]

Okay, I tested and verifed that it works for me too. Signoff branch at working/user/csharp/lp1497307_fix_upgrade_script_signoff

http://git.evergreen-ils.org/?p=working/Evergreen.git;a=shortlog;h=refs/heads/user/csharp/lp1497307_fix_upgrade_script_signoff.

[Jason Stephenson (jstephenson)]

Thanks, Chris!

I've pushed it to master, rel_2_9, and rel_2_9_0.

I will update the tarball and put that on the website.