Horton

Re: Alter or rename enum value

Andrew Dunstan <andrew@dunslane.net>

View thread View on postgr.es
From: Andrew Dunstan <andrew@dunslane.net>
To: Matthias Kurz <m.kurz@irregular.at>, Tom Lane <tgl@sss.pgh.pa.us>
Cc: Jim Nasby <Jim.Nasby@bluetreble.com>, pgsql-hackers@postgresql.org
Date: 2016-03-25T18:50:30Z
Lists: pgsql-hackers 

On 03/25/2016 04:13 AM, Matthias Kurz wrote:
>
> Hopefully at the commitfest at least the transaction limitation 
> will/could be tackled - that would help us a lot already.
>
>

I don't believe anyone knows how to do that safely. Enums pose special 
problems here exactly because unlike all other types the set of valid 
values is mutable.

cheers

andre

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.