Skip site navigation (1) Skip section navigation (2)

Bug in Migration Wizard 2.4.12 with 1-1 relationships

From: "Rohan Carly" <rohan(at)ccu(dot)org(dot)au>
To: <pgadmin-support(at)postgresql(dot)org>
Subject: Bug in Migration Wizard 2.4.12 with 1-1 relationships
Date: 2003-02-21 14:41:50
Message-ID: 001a01c2d9b7$5f4f99d0$0301a8c0@charcoal (view raw or flat)
Thread:
Lists: pgadmin-support
I am trying to use the the Migration Wizard (version 2.4.12) to export a
simple Access database to Pgsql. I notice that the migration wizard fails,
if I have defined 1-1 relationships inside MS Access.

Here is the error log from the wizard:

>Creating table: address_table
>  Copying data...
>  Records Copied: 1
>Creating index: id
>Creating table: name_table
>  Copying data...
>  Records Copied: 1
>Creating index: id
>Creating Foreign Key: address_tablename_table
>
>An error occured at: 21/02/2003 10:25:58 PM: 
>-2147467259: ERROR:  parser: parse error at or near "("
>
>Rolling back... Done.

Here is the last bit of the postgres log from the server:

>NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
>'address_table_pkey
>' for table 'address_table'
>NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index
>'name_table_pkey' f
>or table 'name_table'
>NOTICE:  ALTER TABLE will create implicit trigger(s) for FOREIGN KEY
check(s)
>ERROR:  parser: parse error at or near "("
>NOTICE:  ROLLBACK: no transaction in progress

I have attached a very simple test case .mdb file which triggers the bug.

I use MS Access 2002 SP2 and PostgreSQL 7.2.

- Rohan Carly.

Attachment: testcase.zip
Description: application/x-zip-compressed (30.4 KB)

Responses

pgadmin-support by date

Next:From: Christian MeierDate: 2003-02-21 15:06:07
Subject: Installation of PGADMIN failed under Windows NT4.0
Previous:From: Devdatta GadreDate: 2003-02-21 10:21:54
Subject: problem in pgadmin

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group