The following bug has been logged online:

Bug reference:      4188
Logged by:          Murali Doss
Email address:      [EMAIL PROTECTED]
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

-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

Reply via email to