Thread: Invalid use of null
I'm attempting to migrate an Access database into pgSQL using the Database Migration Wizard. Everything works fine till about half way through when I continue to get the 94: Invalid use of Null error below. Is this a Boolean issue or possibly a problem with Access autonumber? Any help would be greatly appreciated. Thanks
-------------------
Creating table: Members_with_Single_Enrolment_Trans
Copying data...
Records Copied: 6
Creating table: Not Exists
Copying data...
Records Copied: 0
Creating table: NoteCategory
Copying data...
Records Copied: 2
Creating index: NoteTypeID
Creating table: Notes
Copying data...
Records Copied: 6
Creating table: Not Exists
Copying data...
Records Copied: 0
Creating table: NoteCategory
Copying data...
Records Copied: 2
Creating index: NoteTypeID
Creating table: Notes
An error occured at: 4/10/2002 12:52:59 PM:
94: Invalid use of Null
94: Invalid use of Null
Rolling back... Done.
-----------------------
mking@fpa.org
-----------------------
mking@fpa.org
Attachment
Hi, Can you please try the current development build - I've made some changes to the Migration Wizard that may well fix this error? You can download a tarball from: http://cvs.pgadmin.org/cgi-bin/viewcvs.cgi/binaries/. Regards, Dave. -----Original Message----- From: MacDara King [mailto:MKing@FPA.ORG] Sent: 10 April 2002 18:01 To: pgadmin-support@postgresql.org Subject: [pgadmin-support] Invalid use of null I'm attempting to migrate an Access database into pgSQL using the Database Migration Wizard. Everything works fine till about half way through when I continue to get the 94: Invalid use of Null error below. Is this a Boolean issue or possibly a problem with Access autonumber? Any help would be greatly appreciated. Thanks ------------------- Creating table: Members_with_Single_Enrolment_Trans Copying data... Records Copied: 6 Creating table: Not Exists Copying data... Records Copied: 0 Creating table: NoteCategory Copying data... Records Copied: 2 Creating index: NoteTypeID Creating table: Notes An error occured at: 4/10/2002 12:52:59 PM: 94: Invalid use of Null Rolling back... Done. ----------------------- mking@fpa.org