Hi,
I'm using PgAdmin II with Migration Wizard ,all version 1.6.0 and I get
the following error:
Creating table:
An error occured at: 22/04/2004 16.12.10:
-2147467259: ERROR: Relation '' already exists
Does the Migration Wizard cannot perform data-only migrations? help...
Thanks,
Sitraka
Hi,
I'm using PgAdmin II with Migration Wizard ,all version 1.6.0 and I get
the following error:
Creating table:
An error occured at: 22/04/2004 16.12.10:
-2147467259: ERROR: Relation '' already exists
Does the Migration Wizard cannot perform data-only migrations? help...
Thanks,
Sitraka
Thanks Dave,
I understand that numeric is a safer option than float8 for Currency
fields, but in the type map editor I can't set the precision and scale.
If I use numeric without setting precision and scale, Access 97 sees
the field as "text" which is definitely not what I want. If I could
s
Hi Tim,
It's rumoured that D Tim Cummings once said:
> I am trying to migrate an Access 97 database to PostgreSQL 7.3 using
> pgAdmin 1.4.12 and the Migration Wizard 1.4.12. I want to keep using
> the Access 97 front end connected to the PostgreSQL backend.
>
> The default type mapping didn't wor
I am trying to migrate an Access 97 database to PostgreSQL 7.3 using
pgAdmin 1.4.12 and the Migration Wizard 1.4.12. I want to keep using
the Access 97 front end connected to the PostgreSQL backend.
The default type mapping didn't work for me but I discovered that
mapping
Boolean -> int2 (in
On 23 Jun 2003 at 14:35, Dave Page wrote:
> > 23/06/2003 9:04:58 AM - SQL (phorum_conversion): INSERT INTO
> > "newforum1_bodies" ("id", "body", "thread") VALUES ('151',
> > 'Uh, Internal Server Errors may be triggered by a
> > particular browser, but the problem _lies on the server
> > itself
> -Original Message-
> From: Dan Langille [mailto:[EMAIL PROTECTED]
> Sent: 23 June 2003 14:45
> To: Dave Page
> Cc: [EMAIL PROTECTED]
> Subject: RE: [pgadmin-support] Migration wizard cannot
> connect via ODBC
>
>
> On 23 Jun 2003 at 14:35, Dave Page w
> -Original Message-
> From: Dan Langille [mailto:[EMAIL PROTECTED]
> Sent: 23 June 2003 15:18
> To: Dave Page
> Cc: [EMAIL PROTECTED]
> Subject: RE: [pgadmin-support] Migration wizard cannot
> connect via ODBC
>
>
>
> Are you saying that databases
On 23 Jun 2003 at 15:00, Dave Page wrote:
> > On 23 Jun 2003 at 14:35, Dave Page wrote:
> >
> > > > 23/06/2003 9:04:58 AM - SQL (phorum_conversion): INSERT INTO
> > > > "newforum1_bodies" ("id", "body", "thread") VALUES ('151',
> > > > 'Uh, Internal Server Errors may be triggered by a
> > > > p
On 23 Jun 2003 at 8:56, Dave Page wrote:
> > For what it's worth, the migration gets this error:
> >
> > Creating table: newforum1_bodies
> > Copying data...
> >
> > An error occured at: 22/06/2003 5:11:40 PM:
> > -2147467259: ERROR: parser: unterminated quoted string at or near
> > "'tr -d
> -Original Message-
> From: Dan Langille [mailto:[EMAIL PROTECTED]
> Sent: 22 June 2003 22:19
> To: Dave Page
> Cc: [EMAIL PROTECTED]
> Subject: RE: [pgadmin-support] Migration wizard cannot
> connect via ODBC
>
>
> On 22 Jun 2003 at 21:33, Dave Page
On 22 Jun 2003 at 21:33, Dave Page wrote:
> > Thanks. http://pgadmin.postgresql.org/ seems to be down just now...
>
> Looks OK from here.
And now from here.
> From
> http://archives.postgresql.org/pgadmin-support/2003-03/msg00068.php:
>
> FYI - If you have anyone else reporting this issue,
> -Original Message-
> From: Dan Langille [mailto:[EMAIL PROTECTED]
> Sent: 22 June 2003 17:51
> To: Dave Page
> Cc: [EMAIL PROTECTED]
> Subject: Re: [pgadmin-support] Migration wizard cannot
> connect via ODBC
>
>
> Thanks. http://pgadmin.postgresql.
On 22 Jun 2003 at 16:51, Dave Page wrote:
> It's rumoured that Dan Langille once said:
> >
> > It it then that I get the lovely Windows message "pgAdmin II has
> > encountered a problem and needs to close. We are sorry for
> > inconvenience."
>
> >
> > Any ideas? Thanks.
>
> Yes, there is a bu
It's rumoured that Dan Langille once said:
>
> It it then that I get the lovely Windows message "pgAdmin II has
> encountered a problem and needs to close. We are sorry for
> inconvenience."
>
> Any ideas? Thanks.
Yes, there is a bug in the MySQL driver. One of the older ones works fine,
but I
I'm trying to copy the data in a MySQL database over to a PostgreSQL
database. I'm running:
- mysql 3.23.57-nt under Windows XP
- PostgreSQL 7.3.3 under FreeBSD 4.8
- pgAdmin II 1.4.12
Here are my steps:
1 - Connect to my pg db
2 - Select menu item Plugins -> Database Migration Wizard
3 - clic
On 19 Jun 2003 at 20:34, Dave Page wrote:
> You must connect to the server otherwise you will only see plugins that
> don't require a connection to work.
DOH!
That part is mentioned at
http://pgadmin.postgresql.org/pgadmin2.php?ContentID=15 but I missed
the very important point which is at the
> -Original Message-
> From: Dan Langille [mailto:[EMAIL PROTECTED]
> Sent: 19 June 2003 18:36
> To: [EMAIL PROTECTED]
> Subject: [pgadmin-support] Migration Wizard doesn't appear
>
>
> Hi,
>
> I'm using pgAdmin II v 1.4.12 under Windows NT.
Hi,
I'm using pgAdmin II v 1.4.12 under Windows NT. I've downloaded
pgMigration v1.4.12 (after initally trying pgMigration v1.5.60),
installed it to H:\Program Files\pgAdmin2\Plugins (which is where
pgAdmin is installed).
I've run regsvr32 "H:\Program Files\pgAdmin2\Plugins\pgMigration.dll"
Sent: 28 March 2003 03:30
> To: [EMAIL PROTECTED]
> Subject: [pgadmin-support] Migration Wizard problem
>
>
> Hi
>
> I have a problem with a database brought in from an MS Access
> database through the "Database Migration Wizard".
>
> I have
Hi
I have a problem with a database brought in from an MS Access database
through the "Database Migration Wizard".
I have a table ("tblPurchaseOrderDetails") which has a field
("PurchaseOrderDetailID"). In Access this is an "Autonumber" field.
The "default" value generated for "PurchaseOrderDeta
Hi,
I’m using pdAdmin II with Migration Wizard, all version
1.4.12. When I try to migrate a MS Access table in to a schema of a postgres database I get the following error dialog:
--
Creating table:
An error occured
at: 28/02/2003 18.12.31:
-2147467259: ERROR: Relation '' alr
2:23
> To: [EMAIL PROTECTED]
> Subject: [pgadmin-support] Migration Wizard error type mismatch
>
>
> Hi,
>
> I'm trying to use the DB Migration Wizard to migrate an MS
> Access 97 .mdb database to postgres 7.3. I first installed
> mdac and the jet engine, then the
Hi,
I'm trying to use the DB Migration Wizard to migrate an MS Access 97 .mdb
database to postgres 7.3. I first installed mdac and the jet engine, then
the wizard dll. In pgAdmin I connect to my database without any trouble,
but when I click on the migration wizard plugin, I get an errormessage.
T
IL PROTECTED]
> Subject: [pgadmin-support] migration wizard
>
>
> Error when migrate mdb with numbers like columns names
>
> 2002-09-19 12:28:55 - SQL (ayuntamientos): CREATE TABLE
> estadisticaeconomica2001 ( clave varchar(255), 1 float8, 2
> float8, 3 float8, 4 float8, 5 flo
Error when migrate mdb with numbers like columns names
2002-09-19 12:28:55 - SQL (ayuntamientos): CREATE TABLE
estadisticaeconomica2001 ( clave varchar(255), 1 float8, 2 float8, 3
float8, 4 float8, 5 float8, 6 float8, 7 float8, 8 float8, 9 float8, 10
float8, 11 float8, 12 float8, 13 float8, 14
To: Whiteley, Kenneth M.; [EMAIL PROTECTED]
>Subject: RE: [pgadmin-support] Migration Wizard Error: Library not
>registered
>
>
>> -Original Message-
>> From: Whiteley, Kenneth M. [mailto:[EMAIL PROTECTED]]
>> Sent: 30 May 2002 15:29
>> To: [EMAIL PROTECTED
> -Original Message-
> From: Whiteley, Kenneth M. [mailto:[EMAIL PROTECTED]]
> Sent: 30 May 2002 15:29
> To: [EMAIL PROTECTED]
> Subject: [pgadmin-support] Migration Wizard Error: Library
> not registered
>
>
> I am trying to migrate an Access databas
I am trying to migrate an Access database to PostgreSQL (behind our
firewall) using the Database Migration Wizard. I select "Access" as the
Database Type and enter the local path in the ".mdb File". After clicking
on "Next", I get the following message (lifted from the "pgAdmin II_xxx.log"
file)
29 matches
Mail list logo