title: Change column type in a materialized view
body: <p>I have a materialized view based on a table that on which a column type changed. and I'd like to change the column on the materialized view.</p>
  
  <p>I'm aware that a view is based on it's definition but I couldn't find how to updated the select in the definition.</p>
  
  <p>Is the only way to do it to drop the view and re-create it with a new definition?</p>