Hi Keehan,
The log looks odd, there are no datatypes specified for any of the columns!
Can you please check there are valid mappings on the 'Type Map' and try
again - if it still doesn't work, can you send me a copy of the Access db
please?
As for the logfile, check under Tools -> Options. On the Logging tab you can
specify a logfile.
Regards, Dave.
> -----Original Message-----
> From: Keehan Mallon [mailto:keehan_mallon@yahoo.com]
> Sent: 29 April 2002 20:49
> To: Dave Page; pgadmin-support@postgresql.org
> Subject: RE: [pgadmin-support] 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
