From: | Keehan Mallon <keehan_mallon(at)yahoo(dot)com> |
---|---|
To: | Dave Page <dpage(at)vale-housing(dot)co(dot)uk>, pgadmin-support(at)postgresql(dot)org |
Subject: | Re: Error in Database Migration Wizard with Acc ess DB |
Date: | 2002-04-29 19:49:04 |
Message-ID: | 20020429194904.88080.qmail@web11208.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
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(at)vale-housing(dot)co(dot)uk> wrote:
>
>
> > -----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.
__________________________________________________
Do You Yahoo!?
Yahoo! Health - your guide to health and wellness
http://health.yahoo.com
Attachment | Content-Type | Size |
---|---|---|
pgadminII for customer table.log | application/octet-stream | 6.4 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2002-04-30 07:21:36 | Re: Error in Database Migration Wizard with Acc |
Previous Message | Dave Page | 2002-04-29 18:59:45 | Re: Error in Database Migration Wizard with Acc |