Thread: Database Migration Wizard Plugin support

I've installed pgAdmin II 1.4.12 and the Database Migration Wizard Plugin
to copy some tables from a remote db Oracle to a remote db Postgresql.

Great app, but I've met some problems with the plugin.

If I try to copy a table with a date field the transaction fails and the
message that I get is:

-2147467259: ERROR:  Bad timestamp external representation '1997-09-23
00.00.00'

No problem for tables with no date fields except for the fact that
tables are always exported into public!!!

What's wrong?

thanks,
Alessandro Pellegrini

> -----Original Message-----
> From: Alessandro Pellegrini [mailto:alessandro.pellegrini@infoblu.it]
> Sent: 29 April 2003 15:27
> To: pgadmin-support@postgresql.org
> Subject: [pgadmin-support] Database Migration Wizard Plugin support
>
>
> I've installed pgAdmin II 1.4.12 and the Database Migration
> Wizard Plugin to copy some tables from a remote db Oracle to
> a remote db Postgresql.
>
> Great app, but I've met some problems with the plugin.
>
> If I try to copy a table with a date field the transaction
> fails and the
> message that I get is:
>
> -2147467259: ERROR:  Bad timestamp external representation
> '1997-09-23
> 00.00.00'

PostgreSQL is rejecting this because it doesn't recognise the dots
between the time fields (pgAdmin just passes the data on in the default
format for your locale). This is fixed in the latest snapshot.

> No problem for tables with no date fields except for the fact that
> tables are always exported into public!!!

This is also fixed in the latest snapshot. You can download the required
files from the binaries folder at http://cvs.pgadmin.org/. There are
installation instructions in the README.

Regards, Dave.