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
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 |