title: ERROR: cannot alter type of a column used by a view or rule DETAIL: rule _RETURN on view depends on column "status"
body: <p>I am trying to update a column of type integer to numeric(2) in postgres</p>
  <pre><code>ALTER TABLE employee_status
      ALTER COLUMN status TYPE numeric(2);
  </code></pre>
  <p>but getting the error
  ERROR:  cannot alter type of a column used by a view or rule
  DETAIL:  rule _RETURN on view v_employee_details depends on column &quot;status&quot;</p>
  <p>Without dropping or deleting data, how can i achieve this? is there any way to disable the rule or the view</p>