Re: Pulling data from a constraint def - Mailing list pgsql-general

David Fetter <david@fetter.org> writes:
> On Thu, May 13, 2010 at 12:33:08AM -0400, Tom Lane wrote:
>> I'm surprised no one has yet suggested an ENUM type.

> I didn't suggest it because I didn't know about it, but because I've
> found ENUM to be a trap for the unwary.

> Very seldom are people absolutely certain that they'll have one
> particular list of things forever.  The list may grow or shrink, or
> the order may change, and in those cases where the list changes
> somehow, ENUM causes more problems than it solves.

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.

            regards, tom lane