i want to change length of a table column of postgresql database table. this is the error :
ERROR: cannot alter type of a column used by a view or rule
DETAIL: rule _RETURN on view av_viewname depends on column "orderref
is there way to to change column length without destroy views?