0905.schema.use_current_normalize_heading.sql fails with SQl Error

Bug #1418164 reported by Jason Stephenson on 2015-02-04
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Evergreen
Undecided
Unassigned
2.6
Undecided
Unassigned
2.7
Undecided
Unassigned

Bug Description

While running the 0905.schema.use_current_normalize_heading.sql upgrade script on my development system against production data, it dies with the following error:

psql:/home/opensrf/Evergreen/Open-ILS/src/sql/Pg/upgrade/0905.schema.use_current
_normalize_heading.sql:111: ERROR: cannot ALTER TABLE "record_entry" because it
 has pending trigger events

Looks like the script is trying to alter a table after altering data that affects this table.

I'll look into it and post a branch shortly.

Jason Stephenson (jstephenson) wrote :

Branch in on working repo: user/dyrcona/lp1418164

tags: added: pullrequest
Ben Shum (bshum) wrote :

Result from changes made in bug 1415572.

Pushed to master, rel_2_7 and rel_2_6.

Changed in evergreen:
status: New → Fix Committed
milestone: none → 2.8-beta
Changed in evergreen:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers