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 ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
