ERROR: cannot alter type of a column used by a view or rule DETAIL: rule _RETURN on view depends on column "status"
I am trying to update a column of type integer to numeric(2) in postgres ALTER TABLE employee_status ALTER COLUMN status TYPE numeric(2); 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 "status" Without dropping or deleting data, how can i achieve this? is the