Ou company just migrated in the opposite direction. We moved from
MySQL 4.1 to PostgreSQL 8. We had serious issues with MySQL and
foreign key support as well as data validation. For example: MySQL
will simply insert an empty string value for a required field that was
not supplied. We also increased productivity by leveraging triggers
and stored procdures with PostgreSQL.