Re: how to alter an enum type

Поиск
Список
Период
Сортировка
От Martijn van Oosterhout
Тема Re: how to alter an enum type
Дата
Msg-id 20071224183450.GA5848@svana.org
обсуждение исходный текст
Ответ на Re: how to alter an enum type  (Henrique Pantarotto <henpa@terra.com.br>)
Список pgsql-general
On Mon, Dec 24, 2007 at 04:10:45PM -0200, Henrique Pantarotto wrote:
> Hi Richard,
>
> I actually want to change the enum values after I have created and
> associated it to a table colum.
>
> Is it possible?

No. An enum is defined by its members. You can't change a type after it
is created, not for enums, not for any type.

Have a nice day,
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> Those who make peaceful revolution impossible will make violent revolution inevitable.
>  -- John F Kennedy

Вложения

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

Предыдущее
От: Richard Broersma Jr
Дата:
Сообщение: Re: how to alter an enum type
Следующее
От: brian
Дата:
Сообщение: Re: Postgres from PHP in Leopard