Danger of renaming an enum label?

From: Evan Martin <postgresql(at)realityexists(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Danger of renaming an enum label?
Date: 2013-09-12 17:14:09
Message-ID: 5231F661.8010707@realityexists.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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)?

Browse pgsql-general by date

  From Date Subject
Next Message Patrick Dung 2013-09-12 17:26:23 Re: Major upgrade of PostgreSQL and MySQL
Previous Message Mike Christensen 2013-09-12 17:01:05 Re: [GENERAL] Call for design: PostgreSQL mugs