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

Re: Bug in Migration Wizard 2.4.12 with 1-1 relationships

From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
To: <rohan(at)ccu(dot)org(dot)au>
Cc: <pgadmin-support(at)postgresql(dot)org>
Subject: Re: Bug in Migration Wizard 2.4.12 with 1-1 relationships
Date: 2003-02-21 22:14:32
Message-ID: 50076.80.177.99.193.1045865672.squirrel@ssl.vale-housing.co.uk (view raw or flat)
Thread:
Lists: pgadmin-support
It's rumoured that Rohan Carly once said:
> 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.

Hi,

Please try the latest snapshot from the binaries folders at
http://cvs.pgadmin.org/. Instructions are in the readme - you will need to
upgrade all files, not just the migration wizard.
PostgreSQL (and most DBMS') do not refer to foreign keys as relationship
types quite as Access does, so there is no real concept of a 1:1 key as
such. To enforce that, you will need to manually add a unique index on the
fkey column.
Please let me know if you have any trouble.

Regards, Dave.



In response to

pgadmin-support by date

Next:From: Mike TaborskyDate: 2003-02-22 18:38:54
Subject: A Important Question
Previous:From: Dave PageDate: 2003-02-21 21:33:55
Subject: Re: Installation of PGADMIN failed under Windows NT4.0

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