>Please DO NOT use EMUMs. That is old. They are hard to maintain. I also >know from experience that MySql does not check >integrity of enums. It's possible you can have data in a MySql table >column >that is not valid for current enum constraint on that column. >EG: When porting, the enum for a columm (VALID) was "yes, no", but I >found >a few that had "maybe" as data. > >The way to go is to simply implement FOREIGN KEYs. Much easier to >maintain >in PostgreSQL.
Full ack. Andreas -- 2ndQuadrant - The PostgreSQL Support Company
