Forum OpenACS Development: Response to Use CREATE or REPLACE in your upgrade scripts

I'm hitting errors in some of the upgrade scripts while trying to upgrade from 4.5 to 4.6b.

The one I'm at right now is at acs-kernel, but I'm not sure why it's (the upgrade script) doing what it's doing.

In http://dev.openacs.org:8000/cvs/openacs-4/packages/acs-kernel/sql/postgresql/upgrade/upgrade-4.5-4.5.1.sql?rev=1.3&content-type=text/x-cvsweb-markup you can see the file in question.

It loads ../site-node-object-map-create.sql but why? (Vinod, you there?) PG barfs on that because the table is already created and so are all the functions. So why is that in the upgrade script at all?

Next, the functions in the upgrade file are not CREATE OR REPLACE so PG barfs on all of those.