Search Postgresql Archives

Danger of renaming an enum label?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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)?


--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux