recommendation on changing data type of column?

what's the recommended approach here, e.g. changed from text -> double precision and I got this expected error
error: column "time_waiting_for_builds" cannot be cast automatically to type double precision
i'm wondering how to go around these kind of things. would editing the resulting migration sql be an anti pattern? is there a recommended approach to do these things?
Was this page helpful?