Re: Alter or rename enum value

Поиск
Список
Период
Сортировка
От Jim Nasby
Тема Re: Alter or rename enum value
Дата
Msg-id 56F49CF8.8050007@BlueTreble.com
обсуждение исходный текст
Ответ на Re: Alter or rename enum value  (Matthias Kurz <m.kurz@irregular.at>)
Ответы Re: Alter or rename enum value  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Rationalizing code-sharing among src/bin/ directories
Следующее
От: Jim Nasby
Дата:
Сообщение: Re: avg,first,last,median in one query