Database Migration Wizard Plugin for pgAdmin II 1.2.0 does not properly handle empty strings from an MS Access Database.
When processing a column with a data type of Text, which is required but allows 0 length fields, and it encounters an empty string "", instead of passing the value as "", it just leaves out that column, which causes the database to try to set it to NULL, but NULL is not a legal value for the column.
*****************************
Daniel C. Armbrust
Medical Informatics Research
Information Services
Mayo Clinic Rochester
*****************************