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