Subject: Re: Alter or rename enum value
To: Matthias Kurz <m.kurz@irregular.at>, pgsql-hackers@postgresql.org
References: 
 <CAO=2mx6uvgPaPDf-rHqG8=1MZnGyVDMQeh8zS4euRyyg4D35OQ@mail.gmail.com>
From: Andrew Dunstan <andrew@dunslane.net>
Message-ID: <56E049CC.8010201@dunslane.net>
Date: Wed, 9 Mar 2016 11:05:32 -0500
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:38.0) Gecko/20100101
 Thunderbird/38.3.0
MIME-Version: 1.0
In-Reply-To: 
 <CAO=2mx6uvgPaPDf-rHqG8=1MZnGyVDMQeh8zS4euRyyg4D35OQ@mail.gmail.com>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 7bit
Precedence: bulk
Sender: pgsql-hackers-owner@postgresql.org


On 03/09/2016 09:56 AM, Matthias Kurz wrote:
> Hi!
>
> Right now it is not possible to rename an enum value.
> Are there plans to implement this anytime soon?
> I had a bit of a discussion on the IRC channel and it seems it 
> shouldn't be that hard to implement this.
> Again, I am talking about renaming the values, not the enum itself.
>
>


I don't know of any plans, but it would be a useful thing. I agree it 
wouldn't be too hard. The workaround is to do an update on pg_enum 
directly, but proper SQL support would be much nicer.

cheers

andrew


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers