Re: Error in Database Migration Wizard with Acc

> -----Original Message-----
> From: Keehan Mallon [mailto:keehan_mallon(at)yahoo(dot)com]
> Sent: 29 April 2002 17:48
> To: pgadmin-support(at)postgresql(dot)org
> Subject: [pgadmin-support] Error in Database Migration Wizard
> with Access DB
>
>
> 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.

Can you post a logfile with the SQL in it please?

Regards, Dave.