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

From: "Heikki Linnakangas" <heikki(at)enterprisedb(dot)com>
To: "Murali Doss" <murali(dot)doss(at)mphasis(dot)com>
Cc: <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #4188: Array field column (varchar[]) cannot be cast to type "text"
Date: 2008-05-23 12:51:39
Message-ID: 4836BDDB.7000509@enterprisedb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2008-05-23 13:25:02 Re: BUG #4187: function to_tsvector not immutable
Previous Message Murali Doss 2008-05-23 11:05:17 BUG #4188: Array field column (varchar[]) cannot be cast to type "text"