Error: cannot alter type of a column
Hello !
When a run this:
ALTER TABLE telefone ALTER COLUMN nr_telefone TYPE TEXT;
I receive this:
ERROR: cannot alter type of a column used by a view or rule DETAIL: rule _RETURN on view mask.telefone depends on column "nr_telefone"
Is there any more automatic way to alter a type of a masked column (or even delete it) instead of having to drop the masked column's view and rule ?