Thread: BUG - does not handle empty strings properly

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
emptystring "", instead of passing the value as "", it just leaves out that column, which causes the database to try to
setit to NULL, but NULL is not a legal value for the column. 



*****************************
Daniel C. Armbrust
Medical Informatics Research
Information Services
Mayo Clinic Rochester
*****************************

> -----Original Message-----
> From: Armbrust, Daniel C. [mailto:Armbrust.Daniel@mayo.edu]
> Sent: 13 August 2002 22:44
> To: pgadmin-support@postgresql.org
> Subject: [pgadmin-support] BUG - does not handle empty
> strings properly
>
>
> 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.
>

I have updated the current dev code to try to overcome this. Can you try
the snapshot please? If you go to http://cvs.pgadmin.org/, download the
tarball from the binaries folder and install according to the
instructions in the readme.

Regards, Dave.