From: | "Reshat Sabiq" <sabiq(at)purdue(dot)edu> |
---|---|
To: | "'Dave Page'" <dpage(at)vale-housing(dot)co(dot)uk>, <pgadmin-support(at)postgresql(dot)org> |
Subject: | Re: Access-postgreSQL migration (extra invalid foreign key added) |
Date: | 2002-12-23 02:58:02 |
Message-ID: | 000501c2aa2f$1f418e50$b184d380@main |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
-----Original Message-----
From: Dave Page [mailto:dpage(at)vale-housing(dot)co(dot)uk]
Sent: Sunday, December 22, 2002 2:31 PM
To: Reshat Sabiq; pgadmin-support(at)postgresql(dot)org
Subject: RE: [pgadmin-support] Access-postgreSQL migration (extra
invalid foreign key added)
-------
It's certainly possible. The Migration Wizard is a bit hit 'n' miss to
be honest as I wrote it without ever migrating a database except for the
odd test using Northwind/Biblio.
Is it possible to get a schema only copy of your mdb file to look at
please?
-------
Sure. How should I get that schema? I have the postgreSQL statements in
pgAdmin, but I don't know how to obtain the same from Access.
---------
We do sort of assume there are no \n's or \r's in your object names...
---------
That is correct; I do not have new lines in object names. In fact, I
shouldn't have any in that database. But I was thinking it might be
there behind the scenes. But it is strange that only 1 out of 10 foreign
keys get the invalid duplicate statement.
P.S. Thanks for the great tool. Things like that can get done with time.
Sincerely,
r.
From | Date | Subject | |
---|---|---|---|
Next Message | Reshat Sabiq | 2002-12-23 03:13:29 | Re: Can't connect on Windows |
Previous Message | Reshat Sabiq | 2002-12-23 02:45:40 | Re: Can't connect on Windows |