weird result by changing type enum array to text array of a column

Поиск
Список
Период
Сортировка
От Thomas Poty
Тема weird result by changing type enum array to text array of a column
Дата
Msg-id CAN_ctnj4O8F9yg7Y_N48Oy8Zzq=0AN+nmkVYss1UiSDpg=5SYQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: weird result by changing type enum array to text array of acolumn  (rob stone <floriparob@gmail.com>)
Список pgsql-general
Дерево обсуждения
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

В списке pgsql-general по дате отправления:

Предыдущее
От: Tore Halvorsen
Дата:
Сообщение: Replication slots for cascading replication.
Следующее
От: rob stone
Дата:
Сообщение: Re: weird result by changing type enum array to text array of acolumn