From: | "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk> |
---|---|
To: | "Armbrust, Daniel C(dot)" <Armbrust(dot)Daniel(at)mayo(dot)edu>, <pgadmin-support(at)postgresql(dot)org> |
Subject: | Re: BUG - does not handle empty strings properly |
Date: | 2002-08-14 13:11:56 |
Message-ID: | 03AF4E498C591348A42FC93DEA9661B866C8@salem.vale-housing.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
> -----Original Message-----
> From: Armbrust, Daniel C. [mailto:Armbrust(dot)Daniel(at)mayo(dot)edu]
> Sent: 13 August 2002 22:44
> To: pgadmin-support(at)postgresql(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | Armbrust, Daniel C. | 2002-08-14 14:34:16 | Re: download broken |
Previous Message | Raymond Chui | 2002-08-14 12:09:36 | How to execute my trigger when update certain columns but not all? |