[OPEN-ILS-DEV] Upgrade to 2.2-alpha1

[Martha Driscoll]

Dan,
Thanks for the help.  For the record, I am running Debian Squeeze and 
postgresql 9.0.4.  I put a COMMIT; BEGIN; just before the start of the 
0640 update and the 2.1-2.2-alpha1.sql script ran to completion.

At first I thought the problem was that I had not upgraded to 2.1.1 from 
2.1.0.  I did that but still got the error when the upgrade script hit 
the 0640 section.

--
Martha Driscoll
Systems Manager
North of Boston Library Exchange
Danvers, Massachusetts
www.noblenet.org

On 11/24/2011 1:14 PM, Dan Scott wrote:

>> I'm getting this error:
>>
>> psql:Open-ILS/src/sql/Pg/2.1-2.2-alpha1.sql:5622: ERROR:  cannot
>> ALTER TABLE "control_set_authority_field" because it has pending
>> trigger events
>>
>> I'm not sure what to do here. Any suggestions?
>
> Huh. I didn't run into that error during my recent tests of the upgrade
> script in our dev environment (running on PostgreSQL 9.0.4 on Debian
> Squeeze).  What version of PostgreSQL&  distro are you running on, just
> for the sake of comparison?
>
> As far as moving forward, I would suggest customizing your version of
> the upgrade script to add a COMMIT; BEGIN; clause just before the ALTER
> TABLE statement. That way, if the ALTER TABLE or some subsequent
> statement fails, you won't lose all of the changes that have been
> applied successfully to that point. Then you can focus on just the last
> transaction (split it out to a separate file or whatever) and tweak
> until you make your way through everything successfully.
>