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

Collapse
Posted by Vinod Kurup on
Yup Roberto - I'm here 😊

the acs-kernel upgrade script for 4.5 -> 4.5.1 loads site-node-object-map-create.sql because that file and all its tables weren't present in acs-kernel 4.5. (i.e. the official 4.5 tarball). They made it into CVS sometime after the 4.5 release, so they're in the upgrade script. It sounds like you're already running acs-kernel 4.5.1. When did you install 4.5 (and did you do it from the tarball or CVS)? If you installed from CVS, then you probably installed 4.5 after the site-node map file had been added, thus you don't need the upgrade script. Also - none of the functions use CREATE or REPLACE because we hadn't made the decision to use PG7.2 when I wrote that script.