Re: Database migration from Access 2000 - Mailing list pgadmin-support

Hi,

Can you send the whole logfile please?

Regards, Dave.

> -----Original Message-----
> From: Bernd Ruppel [mailto:berupp@yahoo.de]
> Sent: 08 October 2002 19:02
> To: pgadmin-support@postgresql.org
> Subject: [pgadmin-support] Database migration from Access 2000
>
>
>
>
> Dear support team,
>
> I'm trying to migrate an Access 2000 database to
> PostgreSQL 7.20.
>
> While migrating a table that doesn't contain any data
> the following error message occurs:
>
> An error occured at: 08.10.2002 19:07:01:
> 94: Ungueltige Verwendung von Null ("Invalid usage of
> Null")
>
>
> The log file says:
>
> 2002-10-08 18:58:30 - SQL (MLTD_Postgre): BEGIN
> 2002-10-08 18:58:30 - Creating table: tbl_tokens
> 2002-10-08 18:58:30 - Entering Database Migration
> Wizard:frmWizard.txtStatus_Change()
> 2002-10-08 18:58:30 - Entering Database Migration
> Wizard:frmWizard.bIsAutoIncrement()
> 2002-10-08 18:58:30 - Entering Database Migration
> Wizard:frmWizard.bIsAutoIncrement()
> 2002-10-08 18:58:30 - Entering Database Migration
> Wizard:frmWizard.bIsAutoIncrement()
> 2002-10-08 18:58:30 - Entering Database Migration
> Wizard:frmWizard.bIsAutoIncrement()
> 2002-10-08 18:58:30 - Entering Database Migration
> Wizard:frmWizard.bIsAutoIncrement()
> 2002-10-08 18:58:30 - Entering Database Migration
> Wizard:frmWizard.bIsAutoIncrement()
> 2002-10-08 18:58:30 - Entering Database Migration
> Wizard:frmWizard.txtStatus_Change()
> 2002-10-08 18:58:30 - Entering
> pgSchema:pgServer.Property Get Databases()
> 2002-10-08 18:58:30 - Entering
> pgSchema:Databases.Property Get
> Item("MLTD_Postgre")
> 2002-10-08 18:58:30 - Entering
> pgSchema:pgDatabase.Execute("ROLLBACK", 0, -1)
>
> 2002-10-08 18:58:30 - Entering
> pgSchema:pgDatabase.dbConnect()
> 2002-10-08 18:58:30 - Entering
> pgSchema:pgServer.ExecSQL("ROLLBACK",
> "Connection: Provider=MSDASQL.1;Extended
> Properties="DRIVER={PostgreSQL};DATABASE=MLTD_Postgre;SERVER=k
> onfuzius.intern.uni-erfurt.de;PORT=5432;UID=jachimume;PWD=niha
> o;ReadOnly=0;Protocol=6.4;FakeOidIndex=0;ShowOidColumn=0;RowVe
> rsioning=0;ShowSystemTables=0;ConnSettings=;Fetch=100;Socket=4
096;UnknownSizes=0;MaxVarcharSize=> 254;MaxLongVarcharSize=65536;Debug=1;CommLog=1;Optimizer=1;Ksq
> o=1;UseDeclareFetch=0;TextAsLongVarchar=1;UnknownsAsLongVarcha
> r=1;BoolsAsChar=1;Parse=0;CancelAsFreeStmt=0;ExtraSysTablePref
> ixes=dd_;LFConversion=1;UpdatableCursors=1;DisallowPremature=0
> ;TrueIsMinus1=0"")
>
> 2002-10-08 18:58:30 - SQL (MLTD_Postgre): ROLLBACK
> 2002-10-08 18:58:30 - Entering Database Migration
> Wizard:frmWizard.txtStatus_Change()
> 2002-10-08 18:58:30 - Done - 0,26 Secs.
>
>
> Thanks and greetings
>
> Bernd Ruppel
>
>
>
>
> __________________________________________________________________
>
> Gesendet von Yahoo! Mail - http://mail.yahoo.de
> Möchten Sie mit einem Gruß antworten? http://grusskarten.yahoo.de
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>