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 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 on the table are (by
default) deferred while in a transaction, so that line tells the DB to go ahead
and process them right away so we can alter the table in this same transaction.
Dan
