From: | "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk> |
---|---|
To: | "Reshat Sabiq" <sabiq(at)purdue(dot)edu>, <pgadmin-support(at)postgresql(dot)org> |
Subject: | Re: Access-postgreSQL migration (extra invalid foreign key added) |
Date: | 2002-12-23 08:16:04 |
Message-ID: | 03AF4E498C591348A42FC93DEA9661B8128DD0@mail.vale-housing.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
> -----Original Message-----
> From: Reshat Sabiq [mailto:sabiq(at)purdue(dot)edu]
> Sent: 23 December 2002 02:58
> To: Dave Page; pgadmin-support(at)postgresql(dot)org
> Subject: RE: [pgadmin-support] Access-postgreSQL migration
> (extra invalid foreign key added)
>
>
>
>
> -----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.
Sorry, I don't know about Access. The statements from pgAdmin are of
little use though as I want to see what it should have generated, not
what it did.
> ---------
> 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.
You're welcome.
Regards, Dave.
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2002-12-23 08:21:09 | Re: pgAdminII 1.4.12 crash with PostgreSQL 7.3 |
Previous Message | ELECTRONICS | 2002-12-23 03:47:24 | unsubscribe |