Josh Kupershmidt <schmiddy@gmail.com> writes:
> On Thu, May 13, 2010 at 8:08 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> Well, the inability to change the list of values is certainly an
>> unpleasant limitation, but is it so fatal that we should hide the
>> feature from people who could possibly use it? �I think not.
> I happened upon this article relevant to the subject after googling a bit:
> http://www.justatheory.com/computers/databases/postgresql/enforce-set-of-values.html
> One of the comments suggests adding an entry to pg_enum to expand the
> legal values of an existing ENUM type. How safe is this idea?
The trick is for the OID of the added entry to sort in the position you
want it relative to the existing entries. If you don't care about that,
it's fine.
regards, tom lane