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
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
