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.
