Trying to modify column type but get error

I'm running this command

alter table client_details alter column name type character varying(120);

but then get the error

ERROR:  syntax error at or near "view" at character 7
LINE 1: alter view v1 alter column name type character var开发者_C百科ying(120);

I've noticed that a view exists thats causing the problem, how can I alter the type in the vieww, or solve this issue?

Unfortunately PostgreSQL is very strict about this.

You need to drop the view that references that table, then alter the column type and then recreate the view.