Re: how to alter an enum type

From: Martijn van Oosterhout <kleptog(at)svana(dot)org>
To: Henrique Pantarotto <henpa(at)terra(dot)com(dot)br>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: how to alter an enum type
Date: 2007-12-24 18:34:50
Message-ID: 20071224183450.GA5848@svana.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)svana(dot)org> http://svana.org/kleptog/
> Those who make peaceful revolution impossible will make violent revolution inevitable.
> -- John F Kennedy

In response to

Browse pgsql-general by date

  From Date Subject
Next Message brian 2007-12-24 19:48:30 Re: Postgres from PHP in Leopard
Previous Message Richard Broersma Jr 2007-12-24 18:27:55 Re: how to alter an enum type