Обсуждение: Re: Error in Database Migration Wizard with Acc

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

Dave,

I am now successfully using the Database Migration plugin to PgAdmin
II, but I still have a couple of questions:

1) Is it possible to do a migration without OIDs????  If not, how do I
go about dealing with the tables to get rid of the oids?

2) I am still having trouble with the Import plugin.  If I use the
database migration utility to create the tables, then create csv files
from the Access DB, then import them using the plugin I get a failure
from the first row.

Another thing that is annoying is that the transaction continues until
the last row is tried to import and then it fails due to the error in
the first record.  Argh!

Keehan

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