At this point, you can just add a key to the column, set it to max(column) + 1 in an update, and forget about the sequence.

Either way, it's better done in a column that isn't the primary key.