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