Suggestion on column cast automatically to data type

Hi Team,
Thanks for your support.

Could you please suggest on below query.

We are trying to changing the data type of the column, but for every time
triggering "column "parental_path" cannot be cast automatically to type
tsvector".

ALTER TABLE SCHEMA.TABLE ALTER COLUMN COLUMN_NAME TYPE tsvector;

ERROR: column "parental_path" cannot be cast automatically to type tsvector
HINT: You might need to specify "USING parental_path::tsvector".

Q). Are we have any automatically changing mechanism for this type of
conversion?.

>>>>>>>>>>>>>

Even after changing, getting below error.

ALTER TABLE SCHEMA.TABLE ALTER COLUMN COLUMN_NAME TYPE tsvector;
ERROR: word is too long (2087 bytes, max 2046 bytes)

Q)Suggest, how to avoid these situations?.

Thanks for your support.

Regards,
PostgAnn.