Re: Alter or rename enum value - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Alter or rename enum value
Date
Msg-id 25605.1457539654@sss.pgh.pa.us
Whole thread Raw
In response to Re: Alter or rename enum value  (Andrew Dunstan <andrew@dunslane.net>)
Responses Re: Alter or rename enum value
List pgsql-hackers
Andrew Dunstan <andrew@dunslane.net> writes:
> On 03/09/2016 09:56 AM, Matthias Kurz wrote:
>> Right now it is not possible to rename an enum value.
>> Are there plans to implement this anytime soon?

> 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.

I have a vague recollection that we discussed this at the time the enum
stuff went in, and there are concurrency issues?  Don't recall details
though.
        regards, tom lane



pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: Alter or rename enum value
Next
From: Tomas Vondra
Date:
Subject: Re: More stable query plans via more predictable column statistics