Re: BUG #4188: Array field column (varchar[]) cannot be cast to type "text" - Mailing list pgsql-bugs

Murali Doss wrote:
> I have a array field column varchar[] data type and i need to change to text
> data type.but it throwing following error
>
> ALTER TABLE mytable ALTER mycolumn TYPE text;
>
> ERROR: column "mycolumn" cannot be cast to type "text"
> SQL state: 42804

This is not a bug. Use "ALTER TABLE mytable ALTER mycolumn TYPE text
USING ...".

--
   Heikki Linnakangas
   EnterpriseDB   http://www.enterprisedb.com