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. ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster