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

From Christophe Pettus
Subject Re: Alter or rename enum value
Date
Msg-id 4608AEFB-27B4-4DEC-9DEA-39DDAD77FEB7@thebuild.com
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
On Mar 25, 2016, at 11:50 AM, Andrew Dunstan <andrew@dunslane.net> wrote:

> I don't believe anyone knows how to do that safely.

The core issue, for me, is that not being able to modify enum values in a transaction breaks a very wide variety of
databasemigration tools.  Even a very brutal solution like marking indexes containing the altered type invalid on a
ROLLBACKwould be preferable to the current situation. 

--
-- Christophe Pettus  xof@thebuild.com




pgsql-hackers by date:

Previous
From: Gavin Flower
Date:
Subject: Re: Alter or rename enum value
Next
From: ilmari@ilmari.org (Dagfinn Ilmari Mannsåker)
Date:
Subject: Re: Alter or rename enum value