Thread: Invalid use of null

Invalid use of null

From
"MacDara King"
Date:
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

Attachment

Re: Invalid use of null

From
Dave Page
Date:
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