Chris,
> How hard would it be to automatically create enum_ tables in the back
> ground to emulate MySQL's enum type? Sort of like we do with SERIAL
> datatypes... Part of the problem is that MySQL's enum type is so
> braindead from a database design perspective that most of us would not
> be interested in using it. Emulating an int foreign key for another
> created table might make it ok, though.
The mysql2postgres.pl script actually does this (create enum types). It
would be better to auto-create a table and FK, though.
--
--Josh
Josh Berkus
Aglio Database Solutions
San Francisco