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