From: | rob stone <floriparob(at)gmail(dot)com> |
---|---|
To: | Thomas Poty <thomas(dot)poty(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: weird result by changing type enum array to text array of a column |
Date: | 2018-02-05 12:16:20 |
Message-ID: | 1517832980.2860.7.camel@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Mon, 2018-02-05 at 11:26 +0100, Thomas Poty wrote:
> Hello,
>
> I m running 9.5.10 on centos 7.
>
> I have a colmun "TestFields", its type is an array of an enum.
>
> I would like to change the type of this column by an array of text.
>
> So i execute -> alter table "controldetailpromoters" alter column
> "TestFields" type text[]
> The command seems to be correctly executed
> but when I execute a "\d" of my table, the column "TestFields" is
> always an array of the enum....
>
>
> Do you have any idea of what is going wrong?
>
> Thank you.
> Thomas
Hello Thomas,
See chapter 8.7.
Your array "TestFields" contains the internal enum references that are
converted to the defined values by cross referencing to the catalogue
table pg_enum.
I think you will have to add another column to the table as an array of
text, write a little program to cross reference the TestFields array to
pg_enum and update the new column with the textual representation of
the "enum's", then alter your app accordingly.
HTH,
Rob
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas Poty | 2018-02-05 13:09:14 | Re: weird result by changing type enum array to text array of a column |
Previous Message | Thomas Poty | 2018-02-05 10:26:33 | weird result by changing type enum array to text array of a column |