Horton

Alter or rename enum value

Matthias Kurz <m.kurz@irregular.at>

View thread View on postgr.es
From: Matthias Kurz <m.kurz@irregular.at>
To: pgsql-hackers@postgresql.org
Date: 2016-03-09T14:56:34Z
Lists: pgsql-hackers 
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.

Thanks!

Greetings,
Matthias

Commits

  1. Relax transactional restrictions on ALTER TYPE ... ADD VALUE (redux).

  2. Partially restore comments discussing enum renumbering hazards.

  3. Allow adding values to an enum type created in the current transaction.