Postgres Pro
Downloads
Home   >   mailing lists

weird result by changing type enum array to text array of a column - Mailing list pgsql-general

From Thomas Poty
Subject weird result by changing type enum array to text array of a column
Date
Msg-id CAN_ctnj4O8F9yg7Y_N48Oy8Zzq=0AN+nmkVYss1UiSDpg=5SYQ@mail.gmail.com
Whole thread Raw
Responses Re: weird result by changing type enum array to text array of acolumn  (rob stone <floriparob@gmail.com>)
List pgsql-general
Tree view
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 by date:

Previous
From: Tore Halvorsen
Date:
Subject: Replication slots for cascading replication.
Next
From: rob stone
Date:
Subject: Re: weird result by changing type enum array to text array of acolumn