Skip site navigation (1) Skip section navigation (2)

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

From: "Murali Doss" <murali(dot)doss(at)mphasis(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #4188: Array field column (varchar[]) cannot be cast to type "text"
Date: 2008-05-23 11:05:17
Message-ID: 200805231105.m4NB5HTe019402@wwwmaster.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
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

Responses

pgsql-bugs by date

Next:From: Heikki LinnakangasDate: 2008-05-23 12:51:39
Subject: Re: BUG #4188: Array field column (varchar[]) cannot be cast to type "text"
Previous:From: Thomas H.Date: 2008-05-23 09:51:52
Subject: Re: BUG #4186: set lc_messages does not work

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group