Danger of renaming an enum label? - Mailing list pgsql-general

From Evan Martin
Subject Danger of renaming an enum label?
Date
Msg-id 5231F661.8010707@realityexists.net
Whole thread Raw
List pgsql-general
I'd like to rename one of the labels of an enum in PostgreSQL 9.2 This
can easily be done by updating pg_enum, as described at
http://tech.valgog.com/2010/08/alter-enum-in-postgresql.html but I'd
like to understand: what is the danger of doing so? If, as the post
says, the data only references the OID and not the name then it should
be safe, even if the label is used, right? But in that case why is this
not a supported operation (via ALTER TYPE)?


pgsql-general by date:

Previous
From: Mike Christensen
Date:
Subject: Re: Call for design: PostgreSQL mugs
Next
From: Patrick Dung
Date:
Subject: Re: Major upgrade of PostgreSQL and MySQL