The following bug has been logged online:
Bug reference: 4188
Logged by: Murali Doss
Email address: murali(dot)doss(at)mphasis(dot)com
PostgreSQL version: 8.2.6
Operating system: Linux
Description: Array field column (varchar[]) cannot be cast to type
"text"
Details:
Dear All,
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
Please suggest a good solution.
Regards
Murali