Forum OpenACS Q&A: Response to Help with upgrade.sql

Posted by Titi Ala'ilima on
PG doesn't have a very extensive alter table command, and changing
the type of a column is a pretty hairy ordeal.  All I'd suggest is rename the  original topic_id to something else,  add the new topic_id column with a default value, update the column based on the value of
the old column, and then drop the default.