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.
