in last 10 minutes
Creating upgrade scripts
If however recreating the package is inconvenient (it has live data, etc) you can either load the SQL file by hand or bump your package version number in the info file, and add a file named "upgrade/upgrade-<old version>-<new version>.sql" under your sql/postgresql/upgrade/ directory. You'd then visit the APM, click on "install packages" and presto! you'll see your package offered labelled "upgrade" rather than "install". This upgrade file would itself then reference your new .sql file.
I've put this in the OpenACS docs