Re: how to alter an enum type - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Re: how to alter an enum type
Date
Msg-id 20071224183450.GA5848@svana.org
Whole thread Raw
In response to Re: how to alter an enum type  (Henrique Pantarotto <henpa@terra.com.br>)
List 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

Attachment

pgsql-general by date:

Previous
From: Richard Broersma Jr
Date:
Subject: Re: how to alter an enum type
Next
From: brian
Date:
Subject: Re: Postgres from PHP in Leopard