Re: [HACKERS] Enticing interns to PostgreSQL

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