Forum OpenACS Q&A: 4.6.2 upgrade scripts broken (again)
This brings to light yet again, the need for UPGRADE SCRIPTS, and yes I am yelling, there really is no excuse for this. It is much easier now with PG ability to use create or replace and add your procs please.
It is much easier for the modifier to know what he changed than having me go through, diff everything and then figure out what really did change.
Obviously this one got missed. People can help ensure that our final releases include all necessary upgrade scripts IF THEY'LL HELP US BY TESTING when we release our betas.
From one point of view there's never any excuse for any bug, i.e. we should all be perfect at all times. Unfortunately people aren't perfect, we will have bugs, and while it is true that testing won't prove the absence of bugs it sure helps us find them.
I can't test every friggin beta, I do my best, but like you I have client work.
This is a MAJOR bug so I don't see how it could have been missed in testing. You simply can't run a PG version with this proc missing. No site-map, etc.
If this was 4.6.0 I wouldn't be complaining but it isn't and it should have been stable.
I'll make a copy of my production OACS 4.6 site and try the upgrade out (which I was planning to do this week anyway). PostgreSQL 7.2.4 on both sites.
And shouting isn't necessary. I can't say I caught it; testers must do their jobs as much or as well as developers. And shouting just causes lots of noise.