Bruce Momjian wrote:
As far as the ability to add enum values using ALTER TYPE, it seems we would need a pg_enum.enumnum column like we do for pg_attribute.attnum and order on that rather than pg_enum.oid. (Binary upgrade would still need to preserve oids.)
I don't that's necessarily a good way to go - being able to sort by the actual stored value is an efficiency point. I think we might need to look at implementing a more extensible enum type, which would allow new values to be appended to and possibly inserted into the list of labels, but anyway that's really a separate subject from pg_migrator.
cheers andrew -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
