Andrew Kane <and...@chartkick.com> writes: > A better option could be a new "dynamic enum" type, which would have > similar storage requirements as an enum, but instead of labels being > declared ahead of time, they would be added as data is inserted.
You realize, of course, that it's possible to add labels to an enum type today. (Removing them is another story.) You haven't explained exactly what you have in mind that is going to be able to duplicate the advantages of the current enum implementation without its disadvantages, so it's hard to evaluate this proposal. regards, tom lane