Re: [OPEN-ILS-DEV] 2.2 upgrade from rc1

2012-08-15 Thread Martha Driscoll
Thanks Dan, I added that line to the 0710* script and it ran fine as well as the rest of the scripts. Martha Driscoll Systems Manager North of Boston Library Exchange Danvers, Massachusetts www.noblenet.org On 8/14/2012 5:23 PM, Dan Wells wrote: Hello Martha, Yes, you will want to add that

[OPEN-ILS-DEV] 2.2 upgrade from rc1

2012-08-14 Thread Martha Driscoll
I'm trying to upgrade a training server from 2.2-rc1 to 2.2.1. The last script registered in config.upgrade_log is 0709 so I ran 0710 but got an error: Here is what I typed: psql -U evergreen -h localhost -v eg_version=null -f 0710* Here is what I got: ERROR: cannot ALTER TABLE issuance

Re: [OPEN-ILS-DEV] 2.2 upgrade from rc1

2012-08-14 Thread Dan Wells
Hello Martha, Yes, you will want to add that line between the UPDATE and the first ALTER TABLE. Since 0706 and 0710 are two versions of the same idea, the upgrade file probably combines the two (so that is where the line came from). To help explain what is happening, some of the constraints