Error in Database Migration Wizard with Access DB

From: Keehan Mallon <keehan_mallon(at)yahoo(dot)com>
To: pgadmin-support(at)postgresql(dot)org
Subject: Error in Database Migration Wizard with Access DB
Date: 2002-04-29 16:48:07
Message-ID: 20020429164807.85364.qmail@web11202.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Hello list,

I'm having a problem importing an Access DB into PG using the Database
Migration Wizard Plugin for PgAdmin II.

I can see the Access DB, select it, choose tables (or a single table),
tell it to import the data, select foreign keys (or not with only a
single table) and then tell it to migrate. I get an error immediately
after starting the migration:

Creating table: CustomerReturn

An error occured at: 4/29/2002 9:03:04 AM:
-2147467259: Error while executing the query;
ERROR: parser: parse error at or near "PRIMARY"

Rolling back... Done.

Looking at the log file, it looks like it is barfing trying to parse
the query.

If I tell it not to migrate the primary keys I get:

An error occured at: 5/29/2002 9:52:50 AM:
-2147467259: Error while executing the query;
ERROR: parser: parse error at or near ""

Rolling back... Done.

Surely this is some simple error that I am hitting. Anyone have any
ideas???

Thanks,

Keehan

__________________________________________________
Do You Yahoo!?
Yahoo! Health - your guide to health and wellness
http://health.yahoo.com

Browse pgadmin-support by date

  From Date Subject
Next Message Dave Page 2002-04-29 18:59:45 Re: Error in Database Migration Wizard with Acc
Previous Message Alessandro 2002-04-26 07:32:13 unsubscribe