Re: Error in Database Migration Wizard with Acc ess DB

Sure thing Dave!

I got the output from the log window.  Here it is.

Is there a log file that I can grab this stuff from???  I don't seem to
find one???

Thanks for your help this is driving me nuts.  I have seen other
parsing errors as included in my original e-mail.

Cheers,

Keehan






--- Dave Page <dpage@vale-housing.co.uk> wrote:
>
>
> > -----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.


__________________________________________________
Do You Yahoo!?
Yahoo! Health - your guide to health and wellness
http://health.yahoo.com