Re: Error in Database Migration Wizard with Acc - Mailing list pgadmin-support

From Dave Page
Subject Re: Error in Database Migration Wizard with Acc
Date
Msg-id 214E9C0A75426D47A876A2FD8A07426E6652@salem.vale-housing.co.uk
Whole thread Raw
Responses Re: Error in Database Migration Wizard with Acc ess DB
List pgadmin-support

> -----Original Message-----
> From: Keehan Mallon [mailto:keehan_mallon@yahoo.com]
> Sent: 29 April 2002 17:48
> To: pgadmin-support@postgresql.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.

pgadmin-support by date:

Previous
From: Keehan Mallon
Date:
Subject: Error in Database Migration Wizard with Access DB
Next
From: Keehan Mallon
Date:
Subject: Re: Error in Database Migration Wizard with Acc ess DB