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

From Jim Nasby
Subject Re: Alter or rename enum value
Date
Msg-id 56F49CF8.8050007@BlueTreble.com
Whole thread Raw
In response to Re: Alter or rename enum value  (Matthias Kurz <m.kurz@irregular.at>)
Responses Re: Alter or rename enum value
List pgsql-hackers
On 3/24/16 2:00 PM, Matthias Kurz wrote:
> ALTER TYPE bogon DROP VALUE 'cat'; -- not implemented in 9.5 but should
> work in future
> ROLLBACK;

Dropping a value is significantly harder because that value could be in use.

I'm certain there's a really good reason adding new values isn't allowed 
inside of a transaction. It's probably documented in the code.

To answer your question about "what goes into a release", there's really 
no process for that. What goes into a release is what someone was 
interested enough in to get community approval for the idea, write the 
patch, and shepard the patch through the review process. So if you want 
these features added, you need to either: do it yourself, convince 
someone else to do it for free, or pay someone to do it for you.
-- 
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Rationalizing code-sharing among src/bin/ directories
Next
From: Jim Nasby
Date:
Subject: Re: avg,first,last,median in one query