Forum OpenACS Q&A: Re: PG 7.2->7.3 upgrade gotcha?

Posted by Deds Castillo on
The perl script Jun made was very useful.  There's still some problems in upgrading though.  Here is the scenario:

1. We use the script to replace all create statements
2. This will only replace the creates. I've noticed some sql queries which use truncated views in the "from" section of their select statements.
3. The problem now arises because the selects will look for the shorter names but Jun's script now created longer names.

Found out the hard way when my RH8.0 got flaky and I was forced to upgrade to RH9.0.